LEFT(text[,num_chars])
Returns the leftmost @num_chars characters or the left character if @num_chars is not specified.
MID , RIGHT