Neoview SQL Reference Manual (R2.2)

LTRIM Function
The LTRIM function removes leading spaces from a character string.
LTRIM is a Neoview SQL extension.
LTRIM (character-expression)
character-expression
is an SQL character value expression and specifies the string from which to trim leading
spaces. See “Character Value Expressions” (page 208).
Considerations for LTRIM
Result of LTRIM
The result is always of type VARCHAR, with maximum length equal to the fixed length or
maximum variable length of character-expression.
Example of LTRIM
Return 'Robert ':
LTRIM (' Robert ')
See “TRIM Function” (page 418) and “RTRIM Function” (page 395).
360 SQL Functions and Expressions