LEFT()
LEFT(str, len)
str
len
Returns the leftmost len characters from the string str (or NULL if any argument is NULL). The following code returns the string “Chris”:
NULL
SELECT LEFT('Christopher Columbus', '5');