SQL Server Transact Basic to Expert - Removing Trailing blanks using RTRIM


This blog shows how to remove the trailing spaces of a string using the RTRIM in SQL

Example:

SELECT LTRIM('String with Trailing blanks     ')

The expected result would be "'String with Trailing blanks"



Ebook Download
View all
Learn
View all