I am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the RTRIM() function today. The RTRIM() function takes a source string as input and returns a output string with all trailing spaces removed. The following example removes trailing spaces from a favorite movie title of mine.
|
1 2 |
-- Remove trailing spaces select rtrim('WIZARD OF OZ ') as str_phrase |
|
1 2 3 4 5 |
output: str_phrase ------------ WIZARD OF OZ |
One thing to always worry about when using TSQL functions is how will it react with empty strings or NULL values? Both empty strings and NULL values as input return themselves…