Loading lesson path
Concept visual
Start at both ends
Remove trailing spaces from a string:
SELECT RTRIM('SQL Tutorial ') AS RightTrimmedString;The RTRIM() function removes trailing spaces from a string.
Also look at the LTRIM() function.
string )
Required. The string to remove trailing spaces from
SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse
❮ SQL Server Functions