Trims leading and trailing blanks from a character string in a field.
$trim(string)
| string | a character string, or any expression that evaluates to a character string |
Character string.
Use $trim to remove leading and trailing spaces from a character string in a field.
For output purposes, the implicit length of the result returned by $trim is the same as the length of string.
$trim(LastName)
Evaluates to "Smith" if LastName is stored as " Smith ".