Website Designers and Webmasters

Dedicated to all the tasks Webmasters, Website Developers and Website Designers find themselves facing.

SQL Tutorial – Not In

I have an extremely complex SQL database system set up for an email newsletter broadcaster. This piece of code for SQL is what I’ve been looking for for the last week. Here you go:

AND emailaddr NOT IN(SELECT item FROM table WHERE patindex(‘%@%’,emailaddr) > 0 )

That’s all I’m going to say about it right now, look for more SQL Tutorials coming soon.

-Ashton Sanders

Tags: ,

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URL

Leave a comment