"Rich" wrote:

> If a table contains 120 columns and contains data that is about a specific
> subject matter - is there a way to search for the first occurence of a string
> like "bipap" or "bi pap"?  The thing is that you don't know what column would
> contain this kind of text.  I guess I could search each column individually -
> kind of time consuming.  But does sql server have a function to do a table
> search?
>
> Thanks,
> Rich

"Alejandro Mesa" wrote:

> > does sql server have a function to do a table search?
>
> No, It does not have this function.
>
> Here is a link that shows how to accomplish this.
>
> How to search all columns of all tables in a database for a keyword?
> http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
>
>
> AMB
>
> "Rich" wrote:
>
> > If a table contains 120 columns and contains data that is about a specific
> > subject matter - is there a way to search for the first occurence of a string
> > like "bipap" or "bi pap"?  The thing is that you don't know what column would
> > contain this kind of text.  I guess I could search each column individually -
> > kind of time consuming.  But does sql server have a function to do a table
> > search?
> >
> > Thanks,
> > Rich