Convert Delphi code to a SQL function

This job is to create a SQL function that could be used with Advantage database server Such as Update MyTable Set UpcCode=SCAN_RESOLVE(UpcCode); Or Select ScanResolve(UpcCode) UpcCode, Descritpion, … From MyTable; Backround: A lot of times we need to compare in SQL statements 2 fields both are UPC code however one would be lets say 2+code the other one would be code+9 and it should be considered a match (21234567890=12345678909) As of now we accomplish this with Delphi code and would like to transfer this to a SQL function All the Rules are data driven from a table and should remain like this, we constantly add rules to the list I would give you a link to an excel file of all the rules and the Delphi code we currently use All info in Excel file resides in a table named BcHandle and SQL function should refer to that as well so that future additions will work in Delphi and SQL simultaneously Inquire for the link Include the term Blue Magic in your post