I'm trying to build a fraud detecting query on our FedEx Account. We have hundreds of shipments each month. We also have an idea of who the guilty parties are. What I want to do is create a function that takes one parameter, the field I'm searching. I want to compare that field against a another table that lists keywords that we are looking for. I'm assuming I'll have to write some loop that goes through each record in the keywords table then uses the instr (or similar function) to check if that value exists in the field in question. Does anyone know how I could approach that? The looping through a table is the part that really stumps me. If you know of a better way to do it, I'm open to that, as well.