SQL Server LTRIM() Function

Remove leading spaces from a string:

SELECT LTRIM(' SQL Tutorial') AS LeftTrimmedString;

Definition and Usage

The LTRIM() function removes leading spaces from a string.

Note: Also look at the RTRIM() function.

LTRIM( string)

Parameter	Description
string	Required. The string to remove leading spaces from

Works in:	SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse