Clay Shannon wrote:

> I need the SQL to find a value in any column in any table. I know that the
> word "Shigellosis" is in my data somewhere, but I don't know in which table
> or column.

Sorry, that's not a SQL concept. It is interesting that you ask - a
group on the architecture list has been arguing recently about cross
column, cross table searches. Why would anybody want that?

I can offer some (really ugly, really slow) suggestions involving a
query of the system tables to find text blobs and text fields > 11
characters, then transforming the results of that query into a series of
select <whatever> from <wherever> where <whatever> containing
"Shigellosis"... or check for Ivan Prenosil and full text search ...

Regards,


Ann