Help with simple SQL query

Hi All

Can anyone tell me what this simple SQL query would be:

Find all the words "black", "dvd" and "player" from any of the fields "Product", "Brand" or "Description".

Many thanks

accelerator

try something like this

select * from table where product like '%black%' or product like '%dvd%' or product like '%player%'

the above would search the product field...continue the same with your other fields.

|||Use ofFreeTextTable might be appropriate in this case. It's not the simple query you were looking for, but may provide more meaningful results.

help with Reporting

Hi friends!
I have a problem with reporting
rsEvaluationCopyExpired
my reporting copy is a copy of msdn dvd original
what happend?.
Thank
CesartYou may have installed an evaluation version of SSRS 2000
To be sure, check this information
It's stored in the following registry key:
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\80\Reporting
Services\ProductCode
Standard: {B19FEFE7-069D-4FC4-8FDF-19661EAB6CE4}
Enterprise: {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
Developer: {2879CA50-1599-4F4B-B9EC-1110C1094C16}
Evaluation: {7C93251A-BFB4-4EB8-A57C-81B875BB12E4}
Med Bouchenafa
"Cesar" <hgfdhfg@.jksjn.com> a écrit dans le message de news:
%23sXCoymCGHA.2300@.TK2MSFTNGP15.phx.gbl...
> Hi friends!
> I have a problem with reporting
> rsEvaluationCopyExpired
> my reporting copy is a copy of msdn dvd original
> what happend?.
> Thank
> Cesart
>