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: ');

See Also#