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

Karthikeyan Anbarasan
13y
3.1k
0
0

Blog

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"

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

Up Next

SQL Server Transact Basic to Expert - Decreasing a date value to 4 months using SQL query

Ebook Download

View all

Functions in SQL Server: Practical Guide

Read by 9k people

Download Now!

Learn

View all