right
Returns the rightmost "integer_expression" characters of "string_expression".
Syntax
right ( string_expression, integer_expression )Example
right ( [Sales (query)].[Sales staff].[Position code], 3 )Result
Returns the rightmost 3 characters of each position code.