TRIM

(TRIM(text))

Trims leading and trailing blanks from text, returning a text string.

In the following example, the value of vtrim is the text string ABCDE without the leading and trailing blanks.

SET VAR vtrim = (TRIM('   ABCDE   '))