I'd check out <a href="http://itknowledgeexchange.techtarget.com/sql-server/">SQL Server with Mr. Denny</a> for more information...
But I would think that a command similar to the following would do the trick (I don't have a sql server I can test with at the moment):
select * from tablename where fieldname not like '%string1%' and fieldname not like '%string2%' and fieldname not like '%string3%'
Last Wiki Answer Submitted: April 8, 2008 6:58 pm by Jerry Lees5,320 pts.
All Answer Wiki Contributors: Jerry Lees5,320 pts.