List:General Discussion« Previous MessageNext Message »
From:Dan Wright Date:March 21 2003 12:51am
Subject:RE: "where drink is not equal to pepsi
View as plain text  
> Hi guys, 
> Hopefully have an easy question for you guys.
> Whats wrong with this query
> 
> 
> Select * from Tablename where drinks is not = 'pepsi';
> 
> Driving me batty..

select * from CaseSensitiveTablename where drink != 'pepsi';
or
select * from CaseSensitiveTablename where drink not like '%pepsi%';
(the above to be a little wilder)

If that doesn't work - what kind of error are you getting?
Thread
"where drink is not equal to pepsiAndrew Wilson21 Mar
  • RE: "where drink is not equal to pepsiDan Wright21 Mar
  • RE: "where drink is not equal to pepsiDaevid Vincent21 Mar
RE: "where drink is not equal to pepsiAndrew Wilson21 Mar
RE: "where drink is not equal to pepsiJon Wagoner21 Mar
RE: "where drink is not equal to pepsiAndrew Wilson21 Mar