May I also point out that NOT IN vs IN is a different matter than NOT LIKE and LIKE?
NOT IN and IN only consider whole value comparisons where NOT LIKE and LIKE consider partial comparisons to the values.
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.