Progress
SQL-92
Guide and Reference
SUBSTRING Function (ODBC Compatible)
Returns the substring of the character string corresponding to the first argument starting at start_pos and length characters long. If the third argument length is not specified, the substring starting at start_pos up to the end of char_expression is returned.
SYNTAX
EXAMPLE
This example illustrates the SUBSTRING function:
NOTES
- The first argument must be of type CHARACTER.
- The second argument must be of type INTEGER.
- The third argument, if specified, must be of type INTEGER.
- The values for specifying position in the character string start from 1. The very first character in a string is at position 1, the second character is at position 2, and so on.
- The result is of type CHARACTER.
- If any of the argument expressions evaluate to null, the result is null.
char_expression
and the result may contain multi-byte characters.start_pos
is the character position, andlength
specifies a number of characters.COMPATIBILITY
ODBC Compatible
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |