Hello:



My apologies if this is too basic a question. I am working on a ASP based 

search of an Access2002 db. I am trying to include a function to either 

search on _all_ the words that a user enters, or _any_ of the words a 

user enters (right now if a user enters more than one word any results 

that only include one of the words are omitted). I'd like this to be 

selectable at the form. I've tried parsing the words via VBScript but 

that is a nightmare, and I can't figure out how to do it in SQL code. 



Is there a straightforward function or means to do this that I'm too 

inexperienced to know about? :)



thanks for any help.



Ben Clemens

If Request.Form("UseWords") = "All" then



    ' Build search string using AND



Elseif Request.Form("UseWords") = "Any" then



    ' Build search string using OR



End If



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Ben Clemens" <ben@b...>

Subject: [access_asp] search terms, all vs. any





: Hello:

:

: My apologies if this is too basic a question. I am working on a ASP based

: search of an Access2002 db. I am trying to include a function to either

: search on _all_ the words that a user enters, or _any_ of the words a

: user enters (right now if a user enters more than one word any results

: that only include one of the words are omitted). I'd like this to be

: selectable at the form. I've tried parsing the words via VBScript but

: that is a nightmare, and I can't figure out how to do it in SQL code.

:

: Is there a straightforward function or means to do this that I'm too

: inexperienced to know about? :)



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~