sorting

[mullrich24]

I would like to sort the data in a table based on alphabetical order of a name column. I have tried asc but instead of showing the data (name column) in alphabetical order it shows it based on the length of the name. The variable type is varchar2 for the column. I am sure this is a very basic issue. please help

Marc

[nw1234]

I think from reading your message it should work....

try this.. and let me know if it worked like it should (i.e. files listed in alphabetical order by name)

select name, file#, ts# from v$datafile order by name asc;

[kmesser]

mullrich24,

select name from mytable order by upper(name) asc

[mullrich24]

the 'upper' did it.
thanks,

I love it, regards
Marc