TRIM
Returns the string after removing leading, trailing, and repeated spaces in text.
Usage examples
-
TRIM(" a bc ") -
TRIM(tableA.fieldB)
Syntax
TRIM ( value )
-
value- any string expression.
Returns
string - the string with leading, trailing, and repeated white spaces removed.