LTRIM
Returns a VARCHAR value representing a string with leading blanks removed from the left side (beginning).
Behavior Type
Syntax
LTRIM ( expression [ , characters ] )
Parameters
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)