I have an odd problem. I have a list of numbers that serve as extract parameters in a query select ...where x in number list). The numbers are in a specific sequence which does not match the sequence of the extracted data. The user wants the data in the same order as the list of numbers supplied. Is there any easy way to do this within the query? Thanks for any help. Bill William Gaston Systems Designer / Information Technology USG Corporation Chicago, Il 60606 (312) 606-3851 wgaston@xxxxxxx -- //www.freelists.org/webpage/oracle-l