Hi KRoy,
It's quite an open-ended question. Like so many postings I end up asking
for a few more details. It is so atypical to think that somebody would want
to search every column of every table in a database for (for instance) the
word "computer" or something. Equals "computer" or contains "computer"?
Would you want it to match on the word "compute" also in that case?
If you could describe what it is that you are trying to do in a big picture
view it might be easier to propose a solution. Perhaps the answer is to
post the text values into a special "search" table in addition to posting in
the regular tables. Suddenly it becomes significantly easier since all
searching would be done in a single table on a single field. Table and
primary key information would be contained in the search table so you could
refer back to the original source.
So to answer your question, "it depends." :-)
Tom
"KRoy" <an*******@discussions.microsoft.com> wrote in message
news:7D**********************************@microsof t.com...
How can I seach all of the fields of every table in a databae for a
particular value. When it is found, I want to be able to display the table
name and the field name, then continue to search.