TRIM( ) Function

  • Article

Returns the specified character expression with all trailing blanks removed.

TRIM(cExpression)

Return Values

Character

Parameters

  • cExpression
    Specifies the character expression from which TRIM( ) removes all trailing blanks.

Remarks

TRIM( ) is identical to RTRIM( ).

Example

CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'Data\testdata')
USE customer  && Opens Customer table
CLEAR
? 'The contact for '+ TRIM(company) + ' is ' + contact

See Also

ALLTRIM( ) | LTRIM( ) | RTRIM( )