left
Returns the leftmost "integer_expression" characters of "string_expression".
Syntax
left ( string_expression , integer_expression )Example
left ( [Sales (query)].[Sales staff].[Last name] , 3 )Result
Returns the first three characters of each last name.