On 18.03.21 15:45, Basques, Bob (CI-StPaul) wrote: > Maybe check out using the UPPER/LOWER/INITCAP functions in the order by clause? > > Bobb > > > >> -----Original Message----- >> From: basti <mailinglist@unix-solution.de> >> Sent: Thursday, March 18, 2021 9:40 AM >> To: pgsql-general@postgresql.org >> 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 >> >