Re: [GENERAL] ORDER BY options (how to order data as AAA, aaa, BBB, bbb, ... ZZZ, zzz)

[Dinesh Pandey]

SELECT * FROM MY_TABLE ORDER BY LOWER(NAME);     Thanks Dinesh Pandey   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Julian Legeny Sent: Tuesday, May 10, 2005 3:12 PM To: pgsql-general@postgresql.org Subject: [GENERAL] ORDER BY options (how to order data as AAA, aaa, BBB, bbb, ... ZZZ, zzz)   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