LTRIM

Removes all the leading characters in char_expression that are present in char_set and returns the resulting string. The first character in the result is guaranteed not to be in char_set. If you do not specify the char_set argument, leading blanks are removed.

Syntax

LTRIM ( char_expression[ , char_set] )

Notes

The first argument to the function must be of type CHARACTER.

The second argument to the function must be of type CHARACTER.

The result is of type CHARACTER.

If the argument expression evaluates to NULL, the result is NULL.

The char_expression, the character set specified by char_set, and the result can contain multi‑byte characters.

Example

This example illustrates the LTRIM function:

SELECT last_name, LTRIM (addr, ' ')
FROM customer ;

Compatibility

ODBC compatible