![TODAY function [Date and time]](arrow-left.gif){kind=icon}
![TRUNCNUM function [Numeric]](arrow-right.gif){kind=icon}
Removes leading and trailing blanks from a string.
TRIM ( string-expression )
string-expression The string to be trimmed.
The
result data type of a TRIM function is a LONG
VARCHAR. If you use TRIM in a SELECT
INTO statement, you must have a Large Objects Management
option license, or use CAST and set TRIM to
the correct data type and size.
See “REPLACE function [String]” for more information.
The following statement returns the value “chocolate” with no leading or trailing blanks.
SELECT TRIM( ' chocolate ' ) FROM iq_dummy
