RTRIM() function in SQL Server

RTRIM():-This function is used to get the string after the removal of all trailing blanks.


RTRIM ( character_expression )

For example:-

Select RTRIM(‘Vivek Johari  ‘)


Vivek Johari (without blank spaces on Right side)


About vivekjohari

Database Consultant with more than 11.5 years of experience in database designing & programming and DBA related activities.  Had good experience on different databases like SQL Server, MySQL & Oracle, Azure SQL &  Big Data.
This entry was posted in SQL Functions, SQL Server and tagged . Bookmark the permalink.

Leave a Reply