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)
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)