Assuming you want to search for records that contain, for example, "kps" in a specific field, you need to do some transformations to the field (or rather, to the value obtained from the field):

Add a space before and after.

Replace all commas, points, and anything else that might signal "end of word" or "beginning of word", with a space.

As a result, "kpsty, and kpsa." would be converted to: " kpsty and kpsa "

Finally, search for space + "kps" + space.

You may want to embed all this within a UDF.

I am assuming Latin characters; I don't know how this will be affected by Arabic and Urdu characters.

>Hi all
>i am usr code for search the word, in some search option work well but in some have a problem. i am using codepage 1256 and fontch 178(some difficult)
>if i srach a word who completed with to character, show these codes my required along with a word who have three characters, e.g
>i am searching. kps. i alos found kps and also found kpsty, kpsa.
>i only seacr kps.
>difficulty is this, in Arabic and urdu character are spearet .
>thanks
>codes
>

> Set Order To sno
> SET FILTER TO  + ALLTRIM(ThisForm.file.Value) + " " $ upper(fm);
>  OR + ALLTRIM(ThisForm.file.Value) + " " $ upper(sm)