LTRIM
removes leading spaces from an input string.
To remove trailing spaces use the RTRIM function.
To remove both leading and trailing spaces use the TRIM function.
This example removes the leading spaces from the input string.
SELECT LTRIM(' SQL') AS 'Left Trimmed'
Left Trimmed |
---|
SQL |
Syntax of the LTRIM function.
LTRIM(string)
string
-- a character expression, variable, or column name.