>Thanks Mark,
>
>I have tried doing that but it doesn't work. It still sorts the records as if they were still not uppercased. It changes the disorder to uppercase just doesn't sort them properly. Do I have to select everything from the first cursor into a second cursor and order the results since they will now be uppered?
>
>Thanks,
>Tyler

Interesting results in a test I just ran.

DATA:

HColor
Brown
Black
BROWN
Grey
Blonde
Red

SQL:

1. select * from test order by hcolor
2. select upper(hcolor) from test order by 1
3. select upper(hcolor) from test order by hcolor
4. select upper(hcolor) hcolor from test order by hcolor
5. select upper(hcolor) capcolor from test order by capcolor

RESULTS:

Only SQL #2 and 5 returned the results ordered with both variations of Brown together. So you can accomplish this in 1 SQL.