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.