ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

TRIM function [String]

Function 

• Removes leading and trailing blanks from a string.

Syntax 

TRIM ( string-expression )

Parameters 

string-expression    The string to be trimmed.

Standards and compatibility 

• SQL/92    Entry-level feature.

• SQL/99    Core feature.

• Sybase    Not supported by Adaptive Server Enterprise.

See also 

LTRIM function [String]

RTRIM function [String]

Example 

The following statement returns the value chocolate with no leading or trailing blanks.

SELECT TRIM( '   chocolate   ' )