SQL Reference

LTRIM (SYSFUN schema)

>>-LTRIM--(--expression--)-------------------------------------><
 

The schema is SYSFUN.

Returns the characters of the argument with leading blanks removed.

The argument can be of any built-in character string type. For a VARCHAR the maximum length is 4 000 bytes and for a CLOB the maximum length is 1 048 576 bytes.

The result of the function is:

• VARCHAR(4000) if the argument is VARCHAR (not exceeding 4 000 bytes) or CHAR
• CLOB(1M) if the argument is CLOB or LONG VARCHAR.

The result can be null; if the argument is null, the result is the null value.