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



You may also read following recent Post

Submit Post - Article - Ask a Question - Ask an Interview Question - Submit Useful Links