Multiple word search in a table

[mmmsonu]

Hi,

I am working in a project using vb and access.In one of the search form user type keywords seperated by OR clause.Like this-

"brown sugar high quality" or "rice"

What i wanted to do is to find all records with in a column which have words "brown", "sugar", "high", "quality" in any order.It means any word may come either in first, second or in any order within the column.

Whats the best and fastest way to do this.

I heard some thing about full text search index in sql server.But how to do this in access.

Can any one tell me length limitation of one single query.

Hope i make sesnse.

[Ecniv]

.. like '*brown*' OR like '*sugar*' ...


Vince

[mmmsonu]

Can any one tell me length limitation of one single query.
I got following errors when my query become very long -

Query is too complex.

If i use like clause one after another i am going to get the above errors.What should i do to overcome this problem.

[Ecniv]

too complex?

hmmm....

Can you paste the sql statement?
I think there was a limit, but too complex usually means the table links/joins are not done right...


Vince

[mmmsonu]

My query become like this ...

SELECT *
FROM table1
WHERE (name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*' and name like '*brown*' and name like '*rice*' and name like '*quality*' and name like '*high*');