Categories: String
LTRIM
Removes leading spaces or characters from a string.
Syntax
LTRIM(expression varchar) → varchar
- expression: The expression to be trimmed.
Examples
SELECT LTRIM(' dremio')
-- dremio
LTRIM(expression varchar, trim_expression varchar) → varchar
- expression: The expression to be trimmed.
- trim_expression: Leading characters to trim.
Examples
SELECT LTRIM('pancake', 'pan')
-- cake
Was this page helpful?
Glad to hear it! Thank you for your feedback.
Sorry to hear that. Thank you for your feedback.