TRIM
removes excess spaces from a text string.
Syntax:
TRIM(text)
- returns text with any leading or trailing spaces removed, and with any multiple spaces replaced with a single space.
Example:
TRIM(" Good Morning ")
- returns Good Morning.
See also:
CLEAN,
FIND,
PROPER,
REPLACE,
SEARCH,
SUBSTITUTE
Text functions