TRIM
Syntax
TRIM (string_expression)
Description
Returns the specified string_expression with all leading and trailing whitespace removed.
Arguments
| string_expression | Any string. |
Returns
The string_expression with any leading or trailing whitespace removed.
Remarks
Whitespace refers to space, tabs, or certain Unicode characters identified as blanks..
Example
If MyEntity.Name contains the value " ACME Software ":
TRIM(MyEntity.Name)
Returns: "ACME Software"