I am currently working on a new project, where as a business we have to quote on baskets of products supplied to us by a customer. The issue I have is the UOM (Unit of Measure) for pricing purpose’s, I have a table containing Key words, eg, “Mtr” “Ft” “Ml” “Grm” etc…..
What I want to do is this using the table containing the key words, scan the Part description field, held within another table, and flag that record, for further analysis.
E.g. 110038X10FT:REN – in this example “FT” has been found