RTRIM returns the string with trailing whitespace removed.
RTRIM
Supported input column types: STRING
Output column type: STRING
NULL-values: If the value is NULL, the result is NULL
RTRIM ( table.column )
RTRIM ( "Table1"."Column1" )