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