rtrim
Removes trailing blanks from "string_expression". If "string_expression" is null, it returns null.
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.