select name from test order by upper(name), name;=20 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx = [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of = geraldine_2@xxxxxxxxxxx Sent: 30 March 2005 09:07 To: oracle-l@xxxxxxxxxxxxx Subject: order by question ... The result should be : CAT cat Pen pen -- //www.freelists.org/webpage/oracle-l