Just a guess... Order By Right(rtrim(yourColumn),Len(rtrim(yourColumn))-2)
-----Original Message----- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 4:43 PM To: CF-Talk Subject: Sorting problem I've got a database of codes that go like this: RD1,RD2,RD3,RD4,RD5,RD6,RD7,RD8,RD9,RD10,RD11 and so on. Problem is, if you sort it, it ends up like this: RD1, RD10, RD11, etc. Any great, simple way to make sure that they sort the way the client wants: RD1, RD2...RD9,RD10? Ian Portent Interactive Helping clients build customer relationships on the web since 1995 Consulting, design, development, measurement http://www.portentinteractive.com Talk with us: http://projects.portentinteractive.com ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists