Use parenthesis to group conditions inn the way you want them to be executed.

>
>any help to fix this code below to add OR name4=lcName3
>
>

>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
>

>
>thanks