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