Help with Database Search

[Guest]

Website built using FrontPage 2002 that contains an Access 2002 database. I
have set up a search with the DRW and it is functional. I would like to
refine the search results to allow for differences in user inputs.

database table = "products"
search field = "FullDesc"
Search box = "search"
SQL Statement = SELECT Image,FullDesc,CartCode FROM Products WHERE FullDesc
LIKE '%::Search::%'

As an example, if user enters windchimes as the search value I would like
the results page to show "windchimes", "wind chime", "wind chimes"

Any suggestions would be appreciated.

 

[Thomas A. Rowe]

Not possible/feasible, as it would be very difficult to write code that would know what words that
are entered, should then be broken into two words.

Suggest you create a keyword field, and then search both fields, so this way if wind or chimes or
chime is entered, it will result in a match as well.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Guest]

Thank you Thomas

Not possible/feasible, as it would be very difficult to write code that would know what words that
are entered, should then be broken into two words.

Suggest you create a keyword field, and then search both fields, so this way if wind or chimes or
chime is entered, it will result in a match as well.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================