Have a table with around 700 rows. I want to delete all but around 30. How can I specify multiple different values for a given column to not delete. I'm thinking something like:

[sql]
delete * from table where column != ('valueA','valueB','valueC'...'valueN')[/sql]

but I mustn't have the syntax correct because I keep getting errors.

TIA,

Dan