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

Karthikeyan Anbarasan
13y
3k
0
0

Blog

This blog shows how to remove the Leading spaces of a string using the LTRIM in SQL

Example:

SELECT LTRIM(' String with Leading blanks')

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

SQL Server Transact Basic to Expert - Removing Leading 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

Basics of SQL Server

Read by 1.5k people

Download Now!

Learn

View all