sorting problems

[srinivasm]

Hi,
I wanted to sort the data by firstname. And i have used the following Query to do that.

select * from test order by firstname;

Its sorting the properly but its sorting the upper case values first and then its sorting the lower case values. But my requirement is to sort the data,as case insensitive.


Thanks for any help

Srinivas M

[vbaskar]

Hi


select * from emp
order by UPPER(ENAME);

This shd solve u r problem...

Rgds