sorting in oracle?

From: <kilik3000_at_gmail.com>
Date: Wed, 11 Jul 2007 05:59:54 -0700
Message-ID: <1184158794.779496.169910@22g2000hsm.googlegroups.com>

If I create a table:

CREATE TABLE FOO
(

    BAR VARCHAR(5)
);

insert into foo values ('a');
insert into foo values ('b');
insert into foo values ('c');
insert into foo values ('A');
insert into foo values ('B');
insert into foo values ('C');

and run this select statement:

select bar from foo order by bar;

I get back:

BAR

---

A
B
C
a
b
c

Why don't I get back...

BAR

---

A
a
B
b
C
c

-Thx Received on Wed Jul 11 2007 - 07:59:54 CDT