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.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]