$variable in Find to produce exact Find?

[Pat]

I have a script that I am using to do a find where a search term is taken from a join table and put into the search field in the parent table. The search term is put into a $variable which is put into the search field in the Find Mode using Set Field. This is all part of a loop through a series of search variables.

My question is how can I put in the term so that it is an exact search? For example, the desired search term is 'tablet' and tablet gets set into the appropriate field, but the find results include anything with tablet in it (eg tablet, chewable).

I tried

"$variable" ,

"""& $variable & """

and that doesn't work at all.

Any suggestions? Thanks!

[Ender]

Try:

Set Field [ field ; "==" & $variable ]