TRIM

Advantage SQL Engine

Trims a given string of characters from a given string.

Syntax

TRIM( [[ LEADING | TRAILING | BOTH [ str1 ] FROM ] | [ str1 FROM ]] str2 )

Arguments

Remarks

TRIM removes occurrences of str1 from the beginning or end of str2. When passed no trim options, TRIM removes all leading or trailing white space from str2. By specifying LEADING or TRAILING as the trim option, TRIM will remove all leading or trailing occurrences of str1 from str2. The default option is BOTH. If str1 or a trim option is specified, the FROM keyword must precede str2. If either str1 or str2 evaluates to NULL, TRIM returns NULL.

TRIM removes multiple occurrences of str1 from str2. For example:

SELECT TRIM( 'xy' FROM 'xyxyxAyxxy' ) FROM system.iota

would return:

'xAyx'

Note Memo, binary, and image fields are not supported in this Advantage Expression Engine function. If memo, binary, or image fields are used with this expression engine function, the Advantage Expression Engine will be unable to evaluate the expression.

Examples

SELECT TRIM( lastname ) from customers

SELECT TRIM( LEADING FROM lastname ) FROM customers

SELECT TRIM( '.' FROM address ) FROM customers