LTRIM removes the leading blanks from a string expression, and returns the string as type VARCHAR. If string-expression is NULL, LTRIM returns NULL. If string-expression is a string consisting entirely of blank spaces, LTRIM returns the empty string ('').
LTRIM leaves trailing blanks; to remove trailing blanks, use RTRIM. To remove leading and/or trailing characters of any type, use TRIM. To pad a string with leading blanks or other characters, use LPAD. To create a string of blanks, use SPACE.
Note that LTRIM can be used as an ODBC scalar function (with the curly brace syntax) or as an SQL general function.