NB! Updated!
>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)
SET FILTER TO AT(upper(" " + ALLTRIM(ThisForm.file.Value) + " "),upper(" "+fm + "£ " + sm + " "))>0
If codepage is a problem, check the CPCONVERT function.