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.


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


argument-1 Must be alphanumeric.
argument-2 Must be alphanumeric
  1. argument-1 represents the string that is to be trimmed.
  2. 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.

Returned Value

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