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 SandersTags: Database, SQL
Categorised in: SQL
This post was written by Ashton