STRRTRIM

Use the @STRRTRIM function to trim trailing spaces.

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)