SQL question

[Mark Stuart]

on Mon Sep 17 10:59:49 CDT 2012, Klaus on-rev wrote:
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 ;-)


Klaus try concatenating the columns like this:
SELECT Column1, Column2, Column3 FROM Table WHERE (Column1 + Column2 LIKE
'MyCriteria%')

But the column data types must be the same for concatenation. Therefore
CASTing column types into the same data type should work.

Mark