TRIM

Removes the space character or other specified characters from the start or end of a string.

Syntax

string TRIM(string value)

Example

The CustomerName field has "'" at either end and you wish to remove this e.g. 'John Smith':

TRIM("'","CustomerName)

Will return "John Smith".