Sorry, I just saw the post where you stated you are using MySQL. len is not a MySQL function, but length is. try this:
order by length(class) desc, class. Steve ________________________________________ From: Milburn, Steve [EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 2:07 PM To: CF-Talk Subject: RE: Here's an interesting little problem... How about this: order by len(class) desc, class ? Steve ________________________________________ From: Rick Faircloth [EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 2:00 PM To: CF-Talk Subject: RE: Here's an interesting little problem... AA A B C D E etc. > -----Original Message----- > From: Greg Morphis [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 26, 2008 1:41 PM > To: CF-Talk > Subject: Re: Here's an interesting little problem... > > Rick, did you want to see > AA > D > C > B > A > > or > > D > C > B > A > AA > > ? > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:311615 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4