LTRIM
Returns a character expression after it removes leading blanks.
Syntax
LTRIM ( character_expression )
Arguments
character_expression
Is an expression of character or binary data. character_expression can be a constant, variable, or column. character_expression must be of a data type, except text, ntext, and image, that is implicitly convertible to varchar.
Return types
varchar or nvarchar
Examples
SELECT TRIM(' With leading spaces: ');