Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

RTRIM will remove trailing spaces from a string

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