RE: "where drink is not equal to pepsi

[Dan Wright]

> 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?