Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

LTRIM Removes leading spaces from a string

4> 5> DECLARE @STRING_WITH_SPACES VARCHAR(30) 6> DECLARE @STRING_WITHOUT_SPACES VARCHAR(30) 7> SET @STRING_WITH_SPACES = " www.rntsoft.com" 8> 9> SET @STRING_WITHOUT_SPACES = LTRIM(@STRING_WITH_SPACES) 10> 11> SELECT @STRING_WITH_SPACES 12> SELECT @STRING_WITHOUT_SPACES 13> GO ------------------------------  www.rntsoft.com (1 rows affected) ------------------------------ www.rntsoft.com (1 rows affected) 1>