Removing Trailing Blanks : RTRIM « String Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. String Functions
  3. RTRIM
3>
4> SELECT RTRIM('"' + 'www.java2s.com java2s ') + '"'
5> GO

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

(1 rows affected)
1>








12.17.RTRIM
12.17.1.RTRIM will remove trailing spaces from a string.
12.17.2.select RTRIM(' SQL Server ')
12.17.3.Removing Trailing Blanks
12.17.4.select LTRIM(RTRIM(' SQL Server '))
12.17.5.RTRIM a column
12.17.6.CONVERT(varchar(20), RTRIM(au_lname) + ', ' + RTRIM(au_fname)