Removes leading and trailing blanks from a string.
VARCHAR
NVARCHAR
LONG VARCHAR
LONG NVARCHAR
The result data type is a LONG VARCHAR. If you use TRIM in a SELECT INTO statement, you must have an Unstructured Data Analytics Option license, or use CAST and set TRIM to the correct data type and size.