TRIM: Removing Leading and Trailing Occurrences

TRIM(trim_where, source_string, length, pattern, sublength, output)

where:

trim_where

Alphanumeric

Is one of the following, which indicates where to remove the pattern:

'L' removes leading occurrences.

'T' removes trailing occurrences.

'B' removes both leading and trailing occurrences.

source_string

Alphanumeric

Is the string to trim .

string_length

Integer

Is the number of characters in the source string.

pattern

Alphanumeric

Is the character string pattern to remove.

sublength

Integer

Is the number of characters in the pattern.

output

Alphanumeric