Maybe check out using the UPPER/LOWER/INITCAP functions in the order by clause? Bobb > -----Original Message----- > From: basti <mailinglist@xxxxxxxxxxxxxxxx> > Sent: Thursday, March 18, 2021 9:40 AM > To: pgsql-general@xxxxxxxxxxxxxx > Subject: postgresql order lowercase before uppercase > > Think Before You Click: This email originated outside our organization. > > > Hello, > I need to as follow: > > ande > Amma > Anit > Anti > Brac > Cali > .... > > I have try ORDER by name COLLATE 'C'; > > but this order as follow: > > Amma > Anit > Anti > Brac > Cali > .... > ande > > Best Regards >