SQL Server RTRIM() Function

Remove trailing spaces from a string:

SELECT RTRIM('SQL Tutorial ') AS RightTrimmedString;

Definition and Usage

The RTRIM() function removes trailing spaces from a string.

Note: Also look at the LTRIM() function.

RTRIM(string)

Parameter	Description
string	Required. The string to remove trailing spaces from

Works in:	SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse