version 11
LEFT (arithmetic_expression, arithmetic_expression)
Description
The LEFT function returns the leftmost part of the arithmetic_expression passed. The second arithmetic_expression indicates the number of leftmost characters to return as extracted from the first arithmetic_expression indicated.
Example
This example returns the first names and first two letters of the last names from the PEOPLE table:
SELECT FirstName, LEFT(LastName, 2) FROM PEOPLE;
See Also