rtrim
Returns "string_expression" with trailing spaces removed.
Syntax
rtrim ( string_expression )Example
rtrim ( [Sales (query)].[Sales staff].[Last name] )Result
Returns last names with any spaces at the end of the name removed.