Returns the specified expression, trimmed of leading blanks.
ltrim(char_expr | uchar_expr)
is a character-type column name, variable, or constant expression of char, varchar, nchar or nvarchar type.
is a character-type column name, variable, or constant expression of unichar, or univarchar type.
select ltrim(" 123")
------- 123
ltrim, a string function, removes leading blanks from the character expression. Only values equivalent to the space character in the current character set are removed.
If char_expr or uchar_expr is NULL, returns NULL.
For Unicode expressions, returns the lower-case Unicode equivalent of the specified expression. Characters in the expression that have no lower-case equivalent are left unmodified.
For general information about string functions, see “String functions”.
SQL92 – Compliance level: Transact-SQL extension.
Any user can execute ltrim.
Functions rtrim
