Hi, I suspect the answer to the question, "can I use DBIx::Class::Resultset to do a sql query like this": SELECT * FROM countries where iso2letter NOT IN ('GB','IE', 'HK','US'); is "use DBIx::SQL::Abstract". Can someone confirm? Thanx, Dp.