Right trim—%RTRIM
Use this function when you want CDC Replication to trim all trailing blank characters from a character string during replication.
Blank characters that are embedded in a string are not trimmed.
Syntax
%RTRIM(value)Parameters
- value
- Specifies a character column, literal, or column function that returns a character string.
Result data type
Character-based. Returns NULL if value is NULL.
Examples
%RTRIM(Steve Malone
)Returns
the string Steve Malone
with no trailing blank characters.
%RTRIM( Andrea
Moss
)Returns the string Andrea Moss
. The %RTRIM
function does not trim leading and embedded blank characters.
%RTRIM(Anna
Kim<<32>><<32>><<32>>
)Returns the
ASCII string Anna Kim
with no trailing blank characters.