SQL Reference

RIGHT

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

The schema is SYSFUN.

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

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

The result of the function is:

• VARCHAR(4000) if the first argument is VARCHAR or CHAR

• CLOB(1M) if the first argument is CLOB or LONG VARCHAR

• BLOB(1M) if the first argument is BLOB.

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

[ DB2 List of Books | Search the DB2 Books ]