try this

select * from customers
order by upper(surname)

regards
Gary

> If I have uppercase and lowercase names and I select all and order
> by name. It will not sort the uppercase and lowercase names
> properly. For example I get back:
>
> ADAMO APRIL
> ANDERSON MARIELLEN
> Abreu Jonathon
> Aiello James
> Allande Faith
>
> I'm not sure what to change to get the correct alphabetical order in
> this scenario.
>
> -Shaq
>