SQL Reference

LEFT

>>-LEFT--(--expression1--,--expression2--)---------------------><

The schema is SYSFUN.

Returns a string consisting of the leftmost expression2 bytes in expression1.

The first argument is a character string or binary string with maximum length of 1048576 bytes. The second argument must be of INTEGER or SMALLINT dataype.

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
BLOB(1M) if the argument is BLOB.

The result can be null; if any 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 ]