How to Use the LTRIM() Function in SQL Server: A Comprehensive Guide
☰Fullscreen
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