I have some data in a table which I need to 'pull apart'. It's
essentially a ID for a reference but it's not as tidy as I would like
because of the variable length and a little variable in case although
the format is consistent.

V<num> p<num> <Name>.pdf
For example 'V12 p234 The state of the nation.pdf'

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.

I can run it through PHP and RegEx the text and push the new fields
back, but is it possible to do this in a query in Firebird. I THINK what
I'm seeing is that I could search for matching patterns but not actually
extract the match to a new field?

--
Lester Caine - G8HFL
-----------------------------
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk