of the Month
When the TRIM function is used on a string, the trailing blanks are removed. But did you know that if the string is blank then a single blank character is inserted?
But what if we want a null string instead?
There is an interesting function called TRIMN that removes trailing blanks from character expressions and returns a null string if the expression is missing.
Updated February 1, 2006