LEFT(string, number_of_chars) -- Syntax. Takes a string and number of characters to extract starting from the leftmost character. SELECT LEFT('SQL Tutorial', 3) -- This will produce 'SQL' -- Another option to try is the Right syntax.