LTRIM returns a VARCHAR value representing a string with specific characters having been removed from the left side (beginning).
Syntax
LTRIM ( expression [ , characters ] )
Semantics
expression |
(CHAR or VARCHAR) is the string to trim |
characters |
(CHAR or VARCHAR) specifies the characters to remove from the left side of expression. The default is the space character. |
Examples
> SELECT LTRIM('zzzyyyyyyxxxxxxxxtrim', 'xyz');
ltrim
-------
trim
(1 row)