And the question is?

>i use this code below to find names i need to rewrit it .>

> SELECT F4,F1,name4,name3,name2,name1  from x2;
>              where  (name1==lcName and name2==lcName1 and name3==lcName2 and name4==lcName3) OR ( name4==lcName3) ;
>              ORDER by name1,name2,name3,name4;
>               into cursor crsMyCursor readwrite
>
>    &&IF ! FOUND()  OR EMPTY
>
>SELECT F4,F1,name4,name3,name2,name1  from x2;
>              where  ( name4==lcName3) ;  && shure found
>              ORDER by name1,name2,name3,name4;
>               into cursor crsMyCursor readwrite
>
>