Pattern Matching ..Waterfall Logic ... Table Logic?

[Guest]

Greetings!

I'd like to know if "pattern matching" is possible in MS Access?
What's pattern matching?
Table_Rules
FieldA(3) FieldB(3) Product_Desription
..1. .1. = product A
..12 ... = product B
121 ... = product C
..1. 1.. = product D
..11 .C. = product E
F11 D1. = product F

...so you've got a transaction table with records containing FieldA and FieldB,
and you want to find out what the associated Product_Description is .. But,
the rules have to be evaluated in order, so the "less stringent" rules will
kick out
a success early, while the records with the more stringent criteria will
score a
success once they reach the bottom of the rules table.

Links, direction, other help boards appreciated!

Cheers!

 

[Guest]

...or I might have had it backwards..the more stringent rules
are at the top, and the more general rules are at the bottom..
hopefully you get the idea anyway..

 

[Guest]

...regular expressions..didn't know if there was a simpler way... I see
VB.NET has an assembly dedicated too..