SQL Tutorial – Not In

Published by Leave your thoughts

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: ,

Categorised in: SQL

This post was written by Ashton