SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—640322-001
9-3
Character String Functions
See the individual entry for the function.
LPAD Function on page 9-85 Replaces the leftmost specified number of characters in
a character expression with a padding character.
LTRIM Function
on page 9-88 Removes leading spaces from a character string.
OCTET_LENGTH Function
on
page 9-109
Returns the length of a character string in bytes.
POSITION Function
on
page 9-113
Returns the position of a specified substring within a
character string. You can also use LOCATE.
REPEAT Function
on
page 9-127
Returns a character string composed of the evaluation
of a character expression repeated a specified number
of times.
REPLACE Function
on
page 9-128
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-129 Returns the rightmost specified number of characters
from a character expression.
RPAD Function
on page 9-132 Replaces the rightmost specified number of characters
in a character expression with a padding character.
RTRIM Function
on page 9-134 Removes trailing spaces from a character string.
SPACE Function
on page 9-152 Returns a character string consisting of a specified
number of spaces.
SUBSTRING Function
on
page 9-156
Extracts a substring from a character string.
TRANSLATE Function
on
page 9-163
Translates a character string from a source character set
to a target character set.
TRIM Function
on page 9-165 Removes leading or trailing characters from a character
string.
UCASE Function
on page 9-166 Upshifts single-byte characters. You can also use
UPSHIFT or UPPER.
UPPER Function
on page 9-174 Upshifts single-byte characters. You can also use
UPSHIFT or UCASE.
UPSHIFT Function
on
page 9-175
Upshifts single-byte characters. You can also use
UPPER or UCASE.