Strings and order by

[Quoted] I have a table with only a field

create table t
(text varchar2(100));

I put 4 rows in it

insert into t (text) values ('BA000');
insert into t (text) values ('BA001');
insert into t (text) values ('Ba000');
insert into t (text) values ('Ba001');

If I query the table order by text I get the following results:

SQL> select * from t order by text;

TEXT

SQL> It sounds strange to me getting the results case insensitive, I thougth should return all the records 'BA%' and then 'Ba%'.

Am I wrong?

Is there any way to get the results in this way?

Thanks in advance for any clue you can give me.

Regards

Cecilio Received on Fri Sep 23 2005 - 10:12:49 CEST