Why use Left ()Function in SQL Server
- MS Sql Server
- 1137
- March-27-2018
- by Rizwan Saqib
1.Left () Function
The LEFT() function extracts a substring from a string (starting from left).
Queries & Examples
If we want to Trim left side string words by Numbers
1.
Select Left(FirstName ,3)As FirstName
From users_tbl
When we Execute the Query it give us result like this
For Example there is 3 FirstName in Table
Abid ,Jamal,Hanif
It give us Left 3 substring
1.Abi
2.Jam
3.Han
