SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

S-80

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 these string functions:

For more information, see the descriptions of specific functions and Character

Expressions on page C-14.

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.

The character set is one of the single-byte character sets ISO 8859/1 through ISO

8859/9 or one of the double-byte character sets Kanji or KSC5601. For more

information about character sets, see Character Sets on page C-17.

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 ]