MIDDLE

MIDDLE(data, substring);

Using this function, your program will return the middle string according to what you specify.

 

Example:

The field value is  'One Two Three'.


MIDDLE(data, ' ');
Returns 'Two'.


MIDDLE(data, 'One');
Returns '0' (null).


MIDDLE(data, 'T');
Returns  'wo ' (with a blank at the end).