>>-STRIP(string--+------------------------+--)-----------------><
                 '-,-+--------+-+-------+-'      
                     '-option-' '-,char-'        

returns string with leading or trailing characters or both removed, based on the option you specify. The following are valid options. (Only the capitalized and highlighted letter is needed; all characters following it are ignored.)

Both

removes both leading and trailing characters from string. This is the default.

Leading

removes leading characters from string.

Trailing

removes trailing characters from string.

Here are some examples:

STRIP('  ab c  ')        ->    'ab c'
STRIP('  ab c  ','L')    ->    'ab c  '
STRIP('  ab c  ','t')    ->    '  ab c'
STRIP('12.7000',,0)      ->    '12.7'
STRIP('0012.700',,0)     ->    '12.7'