I have two tables, TabA and TabB. TabA contains records that are basically the master template for TabB records.
If anyone changes any rows in TabB to anything other than the values listed in the template, we will update the records daily in TabB to
what they should be.
Columns 1-6 are the criteria, and 7-12 are what they should be set to. In this example, if there are records in TabB
with an 'S' in Col1, anything (wildcard) in Col2, anything (wildcard) in Col3, anything (wildcard) in Col4, anything
3 characters wide, beginning with 'P'and ending with 'N' in Col5, anything in Col6, set them equal to the values in