lcList = "16, 10, 12, 15, 8, 1" CREATE CURSOR crsList (customer_id int, sortord int) FOR i=1 TO ALINES(laList, lcList, ",") INSERT INTO crsList VALUES(VAL(laList[i]), i) ENDFOR select cs.customer_id ; from Customer cs ; JOIN crsList ls ON ls.customer_id = cs.customer_id ; ORDER BY ls.sortord ; into cursor curCustormer>
>select customer_id ; > from Customer ; > where customer_id in (16, 10, 12, 15, 8, 1) ; > into cursor curCustormer >>