I have seen people do this a number of ways. The one that pops into my head currently is using the DECODE function within the ORDER BY. If you Google for that then you will see a number of examples online.
On Wed, Dec 29, 2010 at 11:55 AM, Eric Roberts < ow...@threeravensconsulting.com> wrote: > > 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:340336 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm