Hi Paul,

>Is there a function that I could use that would not include records that have "WASHINGTON" in the description? In other words I only want to match whole words...

Not a single function, but you can easily simulate it with:

At( Space(1)+"WASH"+Space(1), Space(1)+Chrtran(Description,ChrTran(Upper(Description),"ABCDEFGHIJKLMNOPQRSTUVWXYZ",""),Space(255)) + Space(1) ) > 0

The inner Chrtran returns a string that contains all characters that are not the letters A-Z. This is used in the outer ChrTran to remove all thos characters from the description field and replace it with a blank. The intermediate result would for example be:

"Hello World! 123... Hi" -> " Hello World Hi "

All special characters have been replaced by blanks and a blank has been added on both sides. Now you can search for a word by adding a blank to both side of the search string. Use ATC if you need case insensitivity.

Christof