TRIM(text)

The TRIM function removes spaces from text, except single spaces between words.

For example

TRIM("Dear Mr Clinton")

returns "Dear Mr Clinton".

See also:

Other text functions