Removing Leading Blanks : LTRIM « String Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. String Functions
  3. LTRIM
6>
7> SELECT LTRIM(' www.java2s.com java2s.')
8> GO

-----------------------
www.java2s.com java2s.

(1 rows affected)








12.9.LTRIM
12.9.1.LTRIM Removes leading spaces from a string.
12.9.2.The LTRIM() and RTRIM() Functions
12.9.3.Removing Leading Blanks
12.9.4.select LTRIM(' SQL Server ')