[SQL] case insensitive sort for output from SELECT

[Stephen Patterson]

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]

[SQL] Finding table constraints

[Stephen Patterson]

Is there any way to find out what constraints have been set on a table
or on columns in a table?

-- 
Stephen Patterson http://home.freeuk.net/s.patterson/
[EMAIL PROTECTED] (remove spam to reply)
ICBM address 54-22-0N 0-28-0W

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]