---

Syntax:

LEFT(Character_Expression, Integer_Expression)

Returns the specified number of characters from the left hand side of the given character expression.

Code:

 Select LEFT('ABCDE', 3)

Output:

The above code will produce the following result-

 ABC

---