LEFT Function in SQL Server

LEFT()
Returns the left most characters of a string.

Syntax
LEFT(string, length)
 

string
Specifies the string from which to obtain the left-most characters.
 
length
Specifies the number of characters to obtain.

Example :
SELECT LEFT('Chandra',5) 

OutPut
Chand