Is there a NOT LIKE command for SQL? I'm trying to do a report on our ISA server log but I don't want to see anything for www.weatherbug.com
When I do a comamnd like this
SELECT DISTINCT ClientUserName, logTime, DestHost
FROM dbo.[Test Lab]
WHERE (DestHost LIKE '%weatherbug.com') OR
(DestHost LIKE '%wxbug.com')
I get only the weatherbug items. When I throw a NOT in front of LIKEI still get the weather bug Items. Any ideas?