T-SQL Tutorial

T-SQL LTRIM Function


LTRIM function is an string function and delete spaces from the beginning of the string.

LTRIM Syntax:

LTRIM ( string_expression );

LTRIM Example:

DECLARE @mystring varchar(250);
SET @mystring = '      Test LTRIM function - delete spaces from the beginning of my string.';
SELECT LTRIM(@mystring);
GO

Result
Test LTRIM function - delete spaces from the beginning of my string.

See also: T-SQL Functions -> Concat | Left | Len | Lower | Ltrim | RTRIM | Right