SQL question

[Klaus on-rev]

Hi friends,

I know that we can use WILDCARDS in database searches with "LIKE"
...
SELECT * FROM Persons WHERE City LIKE 'sa%'
...

I am wondering if it is possible to search the complete table instead of a particular column.
Know what I mean? Like this pseudocode:
...
SELECT * FROM Persons WHERE ANY_COLUMN LIKE 'sa%'
...

Thanks for any hints or workarounds if this is not possible ;-)


Best

Klaus

--
Klaus Major
http://www.major-k.de
klaus at major.on-rev.com