SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
9-3
Character String Functions
See the individual entry for the function.
LEFT Function on page 9-88 Returns the leftmost specified number of characters
from a character expression.
LOWER Function
on page 9-94 Downshifts single-byte characters. You can also use
LCASE.
LPAD Function
on page 9-99 Replaces the leftmost specified number of characters in
a character expression with a padding character.
LTRIM Function
on page 9-102 Removes the specified characters from the left of the
character string.
POSITION Function
on
page 9-131
Returns the position of a specified substring within a
character string. You can also use LOCATE.
REPEAT Function
on
page 9-145
Returns a character string composed of the evaluation
of a character expression repeated a specified number
of times.
REPLACE Function
on
page 9-146
Returns a character string where all occurrences of a
specified character string in the original string are
replaced with another character string.
RIGHT Function
on page 9-147 Returns the rightmost specified number of characters
from a character expression.
RPAD Function
on page 9-150 Replaces the rightmost specified number of characters
in a character expression with a padding character.
RTRIM Function
on page 9-152 Removes the specified characters from the right of the
character string.
SPACE Function
on page 9-170 Returns a character string consisting of a specified
number of spaces.
SUBSTRING Function
on
page 9-174
Extracts a substring from a character string.
TO_CHAR(<NUMERIC>)
Function on page 9-181
Converts a numeric data to VARCHAR as per the
specified format.
TO_CHAR(<DATETIME>)
Function on page 9-185
Converts datetime data to VARCHAR as per the
specified format.
TRIM Function
on page 9-192 Removes the specified characters from the left side, the
right side, or both sides of a character string.
UCASE Function
on page 9-193 Upshifts single-byte characters. You can also use
UPSHIFT or UPPER.
UPPER Function
on page 9-201 Upshifts single-byte characters. You can also use
UPSHIFT or UCASE.
UPSHIFT Function
on
page 9-202
Upshifts single-byte characters. You can also use
UPPER or UCASE.