TRIM
Description
Removes leading and trailing spaces at the start and end of the string
Syntax
TRIM (text)
Parameters
A string or an expression producing a string
Returns
Text: the text with leading and trailing spaces removed.
Example
IF TRIM ('Some string ') = 'Some string' THEN ...