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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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:[EMAIL PROTECTED] > > > ---------------------------(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
