Subject Re: SQL Puzzle: Two Way String Matching
Author red_october2009
Hi Philip,

Thanks for your valuable help. Sorry to hear you're not feeling well. I will use your suggestion and example. I ended up parsing (like you did) but to a child table. So all the names are just sitting there, both human and pet. So I should be able to iterate through, using your example, or maybe a For Into Do loop in a SP.

(This way, I save a few CPU cycles and did not have to change the original table design)