Remove leading spaces from the string.
SELECT LTRIM(‘ SQL Tutorial’) AS LeftTrimmedString; |
The LTRIM() function removes leading spaces from a string.
Note: Also see the RTRIM() function.
LTRIM(string) |
Parameter |
Description |
string |
Required: The string from which to remove leading spaces. |
Works in: |
SQL Server (from 2008 onward), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse |