SQL Reference

LTRIM

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

The schema is SYSFUN.

Returns the characters of the argument with leading blanks removed.

The argument can be any built-in character string with a maximum length of 1048576 bytes (1M).

The result of the function is:

• VARCHAR(4000) if the argument is VARCHAR 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.

[ DB2 List of Books | Search the DB2 Books ]