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.