SQL search through ALL fields -

i've got database i'm searching through, , want able return rows have @ least 1 field in them matches search criteria. there easier way looping through columns? like:

select *   table  [insert simple code here] fieldstring 

if not can loop, wondering if there simple solution missing.

use ors in clause:

where col1 .... or col2 .... or col3 ...