Example
Extract 3 characters from a string (starting from left):
SELECT LEFT('SQL Tutorial', 3) AS ExtractString;
Definition and Usage
The LEFT() function extracts a number of characters from a string (starting from left).
Syntax
LEFT(string, number_of_chars)