TRIM Function

The TRIM function trims a particular character from the start and end of an alphanumeric string. The type of this function is alphanumeric.

Usage

FUNCTION TRIM (argument-1, [argument-2])

`argument-1`	Must be alphanumeric.
`argument-2`	Must be alphanumeric

argument-1 represents the string that is to be trimmed.
argument-2 represents the character to be trimmed from the start and end of argument-1. Only the first character of argument-2 is used; if omitted, the function assumes a space as argument-2.

The returned value is argument-1 with the leading and trailing argument-2 characters trimmed.