I seem to remember a function in oracle that allows you to set criteria to list elements of a query result to display first, then the rest of the result set follows whatever is listed in the order by statement. I am jsut drawing a total blank on the function name as it has been a couple of years since I have worked with Oracle. Anyone happen to know what i am referring to?
Thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340304 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm