Hi, thanks for looking, Im having difficulty getting the search to work for me the way i want, im no coder, so any help is greatly appreciateed, here we go...

im using a simple udev search with my Access DB, in my access tb i have one table with 1 column and 1 row (this is for testing) its contents are something like the following

|_____column1___|
|big bean counter|

now, when i search 'big bean counter' i get a result, same goes for 'big' 'bean' and 'counter'

however if i search for ' big counter' i get nothing!!

i have this as my sql

SELECT column1 FROM table1 WHERE searchKeywords LIKE '%" + Replace(Results__MMColParam, "'", "''" + "%'

now i was wondering if theres any way to change this sql so that it will search and sho a result for any combination of those 3 words, ie i want a result for 'big counter'

Thanks a bunch for your help and your time,
Allan

Hi,

Follow this link

www.udzone.com/forum/topic.asp?TOPIC_ID=19035&FORUM_ID=3&CAT_ID=2&Topic_Title=Forever+Searching&Forum_Title=Dreamweaver+UltraDev

It should help. Just replace all DB and Tbl names with those of yours.

Cheers

Red Leader