Rick, Could you add an additional column to the database table to store a numeric sorting value? Or a second character column with spaces prepended to the single character and double character values (like " A", " B", " AA", "AAA")?
Carl Rick Faircloth wrote: > I need to order query results by class desc. > > Classes are typically AA, A, B, C, D, etc. > > Order by class desc puts the AA, A in the correct order, > but when all are ordered, I get: > > D > C > B > AA > A > > The only double letters involved in classes are AA, and AAA. > > I need a conditional "order by" statement... > > Order by class desc where class is AA or AAA, > otherwise order by class asc > > Suggestions? > > Thanks, > > Rick > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311596 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4