LEFT(string_exp, count_exp)

Returns the leftmost count characters of string_exp.

 

Example:

SELECT LEFT('ABCDEFG',4) returns ABCD