Progress
SQL-92
Guide and Reference
PREFIX Function
Returns the substring of a character string, starting from the position specified by start_pos and ending before the specified character.
SYNTAX
char_expression
Evaluates to a character string, typically a character-string literal or column name. If the expression evaluates to null,
PREFIX
returns null.start_pos
Evaluates to an integer value.
PREFIX
searches the string specified in the first argument starting at that position. A value of 1 indicates the first character of the string.char_expression
Evaluates to a single character.
EXAMPLEPREFIX
returns the substring that ends before that character. IfPREFIX
does not find the character, it returns the substring beginning atstart_pos
, to the end of the string. If the expression evaluates to more than one character,PREFIX
ignores all but the first character.The following example shows one way to use the PREFIX function:
NOTE
COMPATIBILITY
Progress Extension
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |