Boolean search

External Since: Mar 13, 2008 Posts: 1

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

External Since: Jan 10, 2008 Posts: 596

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" <vg RemoveThis @luccanet.it> 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
>
>
>