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:320530
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
