11.02.2019 22:18, Lester Caine lester@... [firebird-support] wrote:

> Ideally I need to extract the 'V' element and the 'p' element into their
> own fields so I can look up Volume '12' and page '234' or list all the
> pdf's for Volume '12' in page order.

You could use "Regular expression SUBSTRING" described in
firebird3/doc/README.substring_similar.txt.


--
WBR, SD.