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 lowercase Unicode equivalent of the specified expression. Characters in the expression that have no lowercase equivalent are left unmodified.
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute ltrim.
For general information about string functions, see “String functions”.
Function rtrim