"where drink is not equal to pepsi

[Andrew Wilson]

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

A cookie for the right answer..

t   8920 8877 
f   8920 8866 
e   support@stripped 
w   http://www.netwaynetworks.com.au