If you'd like to keep things simple, create a new column and enter the title as you'd like it to be ordered by. Would love to hear if someone has an idea about this also.
Adrian > -----Original Message----- > From: Ian Skinner [mailto:[email protected]] > Sent: 16 March 2009 14:27 > To: cf-talk > Subject: Sort database records as a human not a computer. > > > With SQLServer (2000 I believe) if that matters, which it may well. > > I have a data column that contains titles. I desire the titles to be > sorted alphabetically as a human would not a computer. The records I'm > currently concerned with start with a quote (") and need to start with > a > quote. Ideally I would like the records sorted with these records > placed in order by the first letter inside the quotes like a human > librarian would not to the top of the list as a computer does it. > Since > I'm wishing for this, it would be really cool if the sort also ignored > the other human librarian no goes 'a', 'an' and 'the' that are supposed > to be ignored at the beginning of titles when sorting. > > Luckily this is a very minor requirement and can be ignored if there is > not is not a simple solution out there, but I also can't believe I am > the first programmer that needed to do this with database data, so > maybe > the functionality already exists. > > TIA > Ian ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320532 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
