.png)
LTRIM (SQL Server Compact)
SQL Server 2008
Returns a character expression after removing leading blanks.
The following example removes leading blanks from the names of customers listed in the MyCustomers table.
INSERT INTO Customers
([Customer ID], [Company Name])
VALUES ('TEMP', ' A. Datum Corporation');
SELECT [Customer ID], LTRIM([Company Name]) AS Expr1
FROM Customers
WHERE ([Customer ID] = 'TEMP');
