TRIM

Trims tailing and leading blanks in a string.

Syntax

TRIM(String)

String is a string or a formula which returns a string.

Example

This example returns 'Alea IACTA EST':

TRIM(' Alea IACTA EST ')