SQL

lets say there is a table "contacts" with the columns: lastname, firstname, city, address.... would it be possible to make an sql statement like this (or an equivalent thereof): "select * from contacts where (lastname or firstname or city)=(blah or blah)" granted with only two search parameters, its simple to write out every permutation of the above... but with more it would be impossibly long, is there a way to do that? Thanks Ed