SQL LEFT Function

The SQL LEFT is one of the SQL String Function, which is used to return left most characters from the specified expression. The LEFT function uses its second argument to decide, How many characters it should return.

TIP: The index position in LEFT Function will start from 1, Not 0.

SQL LEFT Function Syntax

The basic syntax of the SQL LEFT Function in SQL Server is as shown below:

• Character_Expression: Please specify the valid Expression on which to want to perform search operation. LEFT Function will write the left most characters from this expression.
• Value: Please specify, how many characters you want to extract from the Character_Expression.

In this article we will show you, How to write LEFT Function in SQL Server 2014 with example. For this, We are going to use the below shown data

SQL LEFT Function Example 1

The LEFT Function is used to return the specified number of characters from the given string. The following query will show multiple ways to use LEFT function.

T-SQL CODE

OUTPUT

ANALYSIS

Below lines of code is used to declare string variable and assigning the string data.

In below statement, We used LEFT function to return five leftmost characters from the @Character_Expression variable. We also assigned new name to that result as ‘SQL LEFT’ using ALIAS Column.

In the next line, We set the second argument as 20, which is greater than the string length so, LEFT function will return all the characters from the @Character_Expression

SQL LEFT Function Example 2

The LEFT function also allows you to select left most characters from the column values. In this example, We are going to return the left four words of all the records present inside the Department Name column

T-SQL CODE

OUTPUT

NOTE: If you observe the second record, there is an Empty space after the Sr.

SQL LEFT Function Example 3

In this example, We are going to find the index position of a @ symbol present in Email column using CHARINDEX function and then we will extract the left most characters up to @ symbol using LEFT Function

T-SQL CODE

OUTPUT

ANALYSIS:

Below statement will return the index position of the @ symbol. It means, CHARINDEX function will check for the index position of @ symbol in each and every record.

We reduced the index position by 1, using the below statement. If you miss this, output include @ symbol as well

Thank You for Visiting Our Blog