Right trim text | TEXT_TRIM_RIGHT
Syntax
TEXT_TRIM_RIGHT( [value] )Parameters
value
The TEXT to trim.
If it is not a TEXT value, it will be converted to one with the STRING operation.
Return Value
A new TEXT with all the white-space characters removed from the end of VALUE.Description
Remove white-space from the end of a TEXT.Examples
TEXT_TRIM_RIGHT(" four score and seven years ") # returns " four score and seven years"TEXT_TRIM_RIGHT("") # returns ""TEXT_TRIM_RIGHT(null) # returns ""TEXT_TRIM_RIGHT(1234) # returns "1234"