Seaching mulitple fields?

[Tmuld]

Hello,

I need to do a seach in multiple columns for a certain word. With SQL
I have to use one specific column right?

I.E. select * from DB where Column1 like '%search%'

That works.

But what if I want to seach multiple columns in the table for the
search word?

You can't do this:

select * from DB where Column1, Column2, Column3 like '%search%'

Is there a way to do this?

Thanks,

Tmuld.

[Andy Williams]

Tmuld,

Try:

SELECT * FROM YourTable
WHERE Column1 LIKE '%search%' OR Column2 LIKE '%search%' ... etc.

-Andy

"Tmuld" <tm******@spliced.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Hello,

I need to do a seach in multiple columns for a certain word. With SQL
I have to use one specific column right?

I.E. select * from DB where Column1 like '%search%'

That works.

But what if I want to seach multiple columns in the table for the
search word?

You can't do this:

select * from DB where Column1, Column2, Column3 like '%search%'

Is there a way to do this?

Thanks,

Tmuld.