I've written a BPM that send up an exception when certain part numbers are entered on Sales Orders, based on our part number nomenclature. Unfortunately, over the years this nomenclature hasn't been strictly adhered to, so I'm having to get "extra" to exclude the correct parts and cannot get a wildcard to work correctly in a condition.
For example, a standard part number may be something like A1454C-3-CI, where the "-3-" refers to the part category. Those are easy to exclude. However, there's also ones like A1454C-3PBA-CI, so I'm trying to get it to trigger on part numbers that contain "-3%-", but that string doesn't work. It doesn't like my percent sign between the 3 and the dash. Works great in a BAQ, but can't get it to work in the BPM, even though it doesn't throw any syntax errors.
Is there a different wildcard that I should be using than % (already tried both * and ^ to no different results).
Best answer by dinman
View original