LTRIM() Function in SQL Server

Rumman Ansari   Software Engineer   2023-03-25   5526 Share
☰ Table of Contents

Table of Content:


Syntax:


LTRIM(Character_Expression) 

Removes blanks on the left handside of the given character expression.

Example: Removing the 3 white spaces on the left hand side of the ' Hello' string using LTRIM() function.

Code:


Select LTRIM('   Hello')

Output:

The above code will produce the following result-


Hello