NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-78
String Functions
•
On physical volumes, subvolumes named ZYS* are reserved for ServerWare SMF.
Do not attempt to create objects or files on subvolumes named in this format.
•
If you specify a logical file name in a FILEINFO, DETAIL command, the
corresponding physical file name is displayed. Similarly, if you execute FILEINFO,
DETAIL for a physical file, its corresponding logical name is displayed.
String Functions
You can use string functions in expressions that involve columns defined with character
data types. You can use a string function anywhere an arithmetic expression is allowed.
NonStop SQL/MP provides the following string functions:
For more information, see the descriptions of specific functions and Character
Expressions on page C-11.
String Literals
A string literal represents a series of characters and consists of that series of characters
surrounded by double or single quotation marks, optionally preceded by a clause that
specifies the character set associated with the characters.
_ISO88591 ... _KSC5601
associates a character set with the string literal.
SUBSTRING Extracts a substring from a given string.
POSITION Searches for a given character pattern in a character string. If the
pattern is found, SQL returns the position of the pattern.
OCTET_LENGTH Returns the length of a character string in bytes.
CHAR_LENGTH Returns the number of characters in a string.
TRIM Removes leading or trailing characters from a character string.
[ _ISO88591 ]
[ _ISO88592 ]
[ _ISO88593 ]
[ _ISO88594 ]
[ _ISO88595 ]
[ _ISO88596 ]
[ _ISO88597 ] { 'string' }
[ _ISO88598 ] { "string" }
[ _ISO88599 ]
[ _KANJI ]
[ _KSC5601 ]
[ _UNKNOWN ]
[ N ]