In mysql, you could use replace instead of decode: order by replace(sFeatureSubHeading, 'General Features','0')
>I will certainly try this out and see if i cna get it to work in a non >oracle world. >thanks!!!! it makes perfectly good sense. > >jay miller > >Brad Howerter wrote: > > >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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
