I've got a list of values in a global array NameArray. I want to check to see if values on the stream are like any of the values in the array. So I'm trying:

for #i in 1 .. ArrayNumValues(@NameArray)

loop

     if name_category not like "'%@NameArray[#i]%'"

     then discard := 1; end if;

end loop;

I don't get any records flagged, even though I know some should hit.

Something's wrong with the quotes and double-quotes (I've tried many combinations). Anyone?