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

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—640322-001
9-88
LTRIM Function
LTRIM Function
The LTRIM function removes leading spaces from a character string.
LTRIM is an SQL/MX extension.
character-expression
is an SQL character value expression and specifies the string from which to trim
leading spaces. See Character Value Expressions on page 6-41.
Considerations for LTRIM
Result of LTRIM
The result is always of type NON ANSI VARCHAR, with maximum length equal to the
fixed length or maximum variable length of character-expression.
Examples of LTRIM
•
Return 'Robert ':
LTRIM (' Robert ')
See TRIM Function on page 9-165 and RTRIM Function on page 9-134.
LTRIM (character-expression)