search multipe fields, compounding fields, like, contains...?

[Mooky Mooksgill]

I would like to search a table for a phrase, or for a partial phrase,
eg on table product - for name or description, or name + descprition.

How does one say select * from product where name + description like
%phrase%
or contains phrase

Currently I can get where name, or where descriotion like %phrase%,
eg, where name like krups, or where description like coffee maker

But if I search for where name like %krups coffee maker% i get no
results. krups is in the name field, coffee maker is in the
description field.

Thanks,
-M

[Simon Hayes]

"Mooky Mooksgill" <st******@hotmail.com> wrote in message
news:8c**************************@posting.google.c om...

I would like to search a table for a phrase, or for a partial phrase,
eg on table product - for name or description, or name + descprition.

How does one say select * from product where name + description like
%phrase%
or contains phrase

Currently I can get where name, or where descriotion like %phrase%,
eg, where name like krups, or where description like coffee maker

But if I search for where name like %krups coffee maker% i get no
results. krups is in the name field, coffee maker is in the
description field.

Thanks,
-M

Have you looked at full-text indexing? From the information you give, it may
be a better solution than LIKE. One of these queries may work (or not,
depending on what the data looks like), but LIKE is quite limited:

select *
from dbo.table
where name + decription like ' %krups%coffee%maker%'

select *
from dbo.table
where name + decription like ' %krups coffee maker%'

Simon