When you do your select, if your db support its, select right(len(col)-2), this should return all of the info except for "RD". You then want to cast it to integer and then sort in your order by clause. On display, simply do: rd#col#
======================================================================= Raymond Camden, ColdFusion Jedi Master for Macromedia Email : [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----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 > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
