>Dear all,
>i want to search the records like this. i am searching "is" in a veriable. it is not a problem.
>but when "is" is in between"his name is khubaib" i use these codes
>
>SET FILTER TO ALLTRIM(thisform.bname.Value)$upper(bname)
>
>these code is also filter is from his. i want only "is" word
>thanks

If I understand what you want correctly, try putting a space on either side of the search string:

SET FILTER TO " " + ALLTRIM(ThisForm.bname.Value) + " " $ UPPER(bname)

Tamar