select LTRIM(RTRIM(' SQL Server ')) : RTRIM « String Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. String Functions
  3. RTRIM
3> select LTRIM(RTRIM(' SQL Server '))
4> GO

------------
SQL Server

(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)