if you order by upper(name) then it will mix them all together, so you won't have capital before lowercase, but it will put all the lowercase a before the uppercase b "Julian Legeny" <julo@xxxxxxxxxxxxxxxxxx> wrote in message news:559596967.20050510114150@xxxxxxxxxxxxxxxxxxxxx > Hello, > > I have following problem: > > I have table MY_TABLE with following records: > > NAME > ----------- > ccc > CCC > AAA > aaa > bbb > BBB > > When I use default select that sort all data by NAME: > > SELECT * FROM MY_TABLE ORDER BY NAME; > > result is following: > > NAME > ----------- > AAA > BBB > CCC > aaa > bbb > ccc > > > But I would like to sort all data as following: > > NAME > ----------- > AAA > aaa > BBB > bbb > CCC > ccc > > > How can I write sql command (or set up ORDER BY options) for selecting that? > > > Thank you in advance for answer, > best regards, > > Julian Legeny > > mailto:julo@xxxxxxxxxxxxxxxxxx > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
