You can do it with the Database Search wizard or server behavior. If you use the search type "keyword" it will allow you to multi-select columns to search. I think the only limitation is that all the columns would have to be the same data type, so you couldn't have a bunch of varchar and integer columns in the same search since it would give an error when searching an integer column with a text value.