LTRIM
Removes leading spaces or characters from a string.
Syntax
LTRIM(expression varchar, trim_expression varchar) → varchar
expression: The expression to be trimmed.
trim_expression: Leading characters to trim. If this parameter is not specified, then spaces will be trimmed from the input expression.
Examples
SELECT LTRIM('pancake', 'pan')
-- cake
SELECT LTRIM('pancake', 'abnp')
-- cake
SELECT LTRIM(' spice')
-- spice
Last updated
Was this helpful?