Shaq,

> 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.

It's a matter of using the correct collation for your
choosen character set.

What character set and collation was the character
field created with?


Best Regards,
Thomas Steinmaurer
LogManager Serie - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com