On 11/02/2019 22:51, blackfalconsoftw...@outlook.com [firebird-support] wrote: > It may be more convenient to pull out data via a Regex expression in SQL > code but it is rather redundant since all of the major development > languages already support extensive Regex pattern matching capabilities...
20 years ago I'd just have rolled a UDF to give me the two values which I could then use in the database. It looks like I still need to do that. Or as you say cycle all the data through PHP ... which messes up simply upgrading the databases via a local script. -- 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