LTRIM Function In SQL Server 2008
In this article i will explain how to use LTRIM Function in SQL.
Introduction
LTRIM() Function returns a character expression after it removes leading blanks.
Syntax
SELECT LTRIM (character_expression)
|
where character_expression could be a constant variable or column.
Example
1. LTRIM() function used to remove leading spaces from given string.
2. Suppose we have table named Employee as.
To return the the "F_Name " column after removing leading blanks.