LEFT
Description
Returns the right part of a character string with the specified number of characters. (RIGHT in Transact-SQL).
Sample Source Pattern
Syntax
LEFT ( character_expression , integer_expression )
Examples
Code:
SELECT LEFT('John Smith', 5) AS FIRST_NAME;
Output:
FIRST_NAME|
----------+
John |
Last updated