B Branagan Registered User. Local time Today, 01:56 Joined May 27, 2004 Messages 31 Jun 23, 2004 #1 Hi, I want to make a query where it displays everything apart from if it has say "hello" in the field. what criteria do i use ? thanks in advance
Hi, I want to make a query where it displays everything apart from if it has say "hello" in the field. what criteria do i use ? thanks in advance
SQL_Hell SQL Server DBA Local time Today, 01:56 Joined Dec 4, 2003 Messages 1,361 Jun 23, 2004 #2 Hi, Use SELECT * FROM table WHERE field NOT LIKE '*hello*'
B Branagan Registered User. Local time Today, 01:56 Joined May 27, 2004 Messages 31 Jun 23, 2004 #3 works like a charm, cheers
