LTRIM

LTRIM removes blanks from the beginning of a character string expression.

Syntax

LTRIM(CharacterExpression)

CharacterExpression

A  LONG VARCHAR data type, or any built-in type that is implicitly converted to a string.

Results

A character string expression. If the CharacterExpression evaluates to NULL, this function returns NULL.

Example

splice> VALUES LTRIM('      Space Case   ');
1
-----------
Space Case      	--- This is the string 'Space Case   '

See Also