Is there any way to alphabetically sort the output of a select statement correctly? what I'm using at the moment is SELECT data FROM table ORDER BY DATA ASC which gives (for example) A B C a b Is there any way to rig this so that it sorts 'properly', i.e. both the a's come together? Given what I'm working on, I could use either a pure SQL solution or some perl to put around the perl DBI. -- It's a great big universe and we're all really puny, just tiny little specks 'bout the size of Mickey Rooney -- Animaniacs -- -- -- -- -- -- -- -- -- -- Stephen Patterson [EMAIL PROTECTED] (Remove SPAMOFF to reply) http://home.freeuk.net/s.patterson/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
