Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Removes leading and trailing blanks from a string.
TRIM( string-expression )
string-expression The string to be trimmed.
The following statement returns the value chocolate with no leading or trailing blanks.
SELECT TRIM( ' chocolate ' );
Syntax