Why use Left ()Function in SQL Server
By Rizwan Saqib Posted on March-27-2018 725
MS Sql Server
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
By Rizwansaqib966 27-Mar-2018
Views 725
