Basic SQL question

[Aldwin Pollefeyt]

On Sep 22, 2004, at 03:30, Gregory Kowalski wrote:

>
> SELECT * FROM table ORDER by name
>
> is
>
> PHILIP
> Paul
> Ziggy
>
> instead of
>
> Paul
> PHILIP
> Ziggy
>
> (ascending order)

Because in the ASCII table, the capitals come before non-capitals   
asc(72)=H; asc(97)=a

Not sure but try:

SELECT * FROM table ORDER by UPPER(name)   ????

Greetings,

Aldwin

Started with RB on the 7th of June 2004