Remove trailing whitespace from strings.
Query
Column1
RTRIM ( "Table1"."Column1" )
Input
Table1
Column1 : STRING |
---|
' a' |
' ' |
'' |
null |
' ' |
' w Q f xJd5pkTPd4bjoBwYc4q0P4 ' |
'JeCouStHuBERtFustyPOLoris' |
' %@#$%^&*()_+ ' |
Output
Result
Column1 : STRING |
---|
' a' |
'' |
'' |
null |
'' |
' w Q f xJd5pkTPd4bjoBwYc4q0P4' |
'JeCouStHuBERtFustyPOLoris' |
' %@#$%^&*()_+' |