Here's an Oracle solution: ORDER BY iApplication, iModule, DECODE(sFeatureSubHeading, 'General Features','0', sFeatureSubHeading)
This will cause General Features to sort as if it were '0', which will move it up to the front of the list. >Hello list - I have a query that specifys a specific order - I need to >take the last value in the order by statement and alter that... for ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4