Use the @STRRTRIM function to trim trailing spaces.
@STRRTRIM
Syntax
@STRRTRIM (string)
string
Can be the name of a character column or a literal string. Enclose literals within quotes.
Example
street_address = @strrtrim(address)
Scripting on this page enhances content navigation, but does not change the content in any way.