Progress
SQL-92
Guide and Reference
SUFFIX Function
Returns the substring of a character string starting after the position specified by start_pos and the second char_expression, to the end of the string.
SYNTAX
char_expression
Evaluates to a character string, typically a character-string literal or column name. If the expression evaluates to null,
SUFFIX
returns null.start_pos
Evaluates to an integer value.
SUFFIX
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.
EXAMPLESUFFIX
returns the substring that begins with that character. IfSUFFIX
does not find the character afterstart_pos
, it returns null. If the expression evaluates to more than one character,SUFFIX
ignores all but the first character.This example illustrates two ways to use the SUFFIX function:
NOTE
COMPATIBILITY
Progress Extension
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |