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