What is the use of Left function in Sql Server?

 Posted by vishalneeraj-24503 on 3/17/2014 | Category: Sql Server Interview questions | Views: 680 | Points: 40
Answer:

Left function is an in-built Sql Server function used for returning the specified number of characters from a given string starting from the very beginning i.e. from left side of the string.In short,Left function returns the left part of a character string with the specified number of characters.

Syntax:
Left(String Value,Number of Characters)

Where:
String Value -> It provides string value(field name or expression) that will be used as our input.
Number of Characters -> It provide number of characters that we would like to receive from the String Value we provided in the first expression.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response