sql syntax

Two tables...A and B. Table A has a character field with words: CAT DOG ETC. Table B has a longer character field with words: SPONGE FISHERMAN OWNER'S OF DOGS etc. I want set up a foreach which goes through table B and if it finds Table A entries, continue foreach or delete the record or whatever. So it would throw out record #2 in table B "OWNER's OF DOGS" because of the entry in Table A "DOG." Since this is not an exact match which would be easy, I have tried all wildcard permutations I can think of with match, like, etc. Nada. Is there an efficient way to do this? -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own