TRIM( TEXT )

Returns a Text value

You can use the TRIM function to remove any white space characters from the beginning and end of a Text variable, for example:

would be returned as:

TRIM( TEXT ) is equivalent to STRIP( TEXT, " \t\l", TRUE, TRUE ). See STRIP( TEXT, TEXT, TRUE_FALSE, TRUE_FALSE ) for more information.