Boolean search   

Hi all!
This is my problem, I hope you can help me...
I have an asp web site.
I want to search, for exemple in a table of addresses, the string 
"apple+table", to have all the record in my table where in a list of fields 
(like name, address, telephon) there is the word apple and the word table.
How Can I perform this kind of search?

Sorry for my english and thanks!
Vg

date: Thu, 13 Mar 2008 10:33:28 +0100   author:   vg

Re: Boolean search   

Vg,

Try this, changing the names to the proper names for you table, etc.

SELECT KeyValue, Description
FROM CustomerAddress
WHERE CONTAINS((Name, Address, Telephon), ' "Apple" AND "Table" ')

RLF

"vg"  wrote in message 
news:uSGWI1OhIHA.5900@TK2MSFTNGP02.phx.gbl...
> Hi all!
> This is my problem, I hope you can help me...
> I have an asp web site.
> I want to search, for exemple in a table of addresses, the string 
> "apple+table", to have all the record in my table where in a list of 
> fields (like name, address, telephon) there is the word apple and the word 
> table.
> How Can I perform this kind of search?
>
> Sorry for my english and thanks!
> Vg
>
>
>

date: Thu, 13 Mar 2008 13:20:50 -0400   author:   Russell Fields