Why use Left ()Function in SQL Server
- MS Sql Server
- 787
- 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
Jack Carter
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
you can view the more detail via link https://www.youtube.com/watch?v=HpZgwHU1GcIChing xang
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
Danial Comb
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
Jack Carter
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!