Do you mean you want all of the customer_id's with 16 first then 10 then 12 etc?

John

>

>select customer_id  ;
>  from Customer ;
> where customer_id in (16, 10, 12, 15, 8, 1) ;
>  into cursor curCustormer
>

>
>How can I order the result cursor according to data in the set of inlist expressions
>
>Thank in advance
>
>Ali Altun