It seems that when doing a search the query looks for the searchtext using a 'Like' instead of an 'Equal'.

How can I get the search query to do an 'Equal'?

For example, if I search on radia then the results will be anything with the word raia in it.

Instead I want to search on radia and only get radia not radiation, radiate or anything else where radia is part of the work.

It seems that the query is (select * from table where field like 'radia*' instead of select * from table where field = 'radia';)

How can this be accomplished?

Terry