Is there a way in SQL to search for a value in ALL fields of ALL records...

for example, when you do

Select * from tblTest WHERE [Name] = 'kleinma'

but what if kleinma could be any field.. not just name.. and i wanted to do a search like that...