Hi Dennis,

INDEX ON UPPER(lastname) TAG lastname

or

SELECT *, UPPER(lastname) AS sortkey ;
   FROM mytable ;
   ORDER BY sortkey

Hope this helps,
Gavin...

>How do I get a key to sort in alpha order without regarding case. For instance take the following.
>
>Default sort order
>Adams
>Jones
>Smith
>deVant
>
>What I want is
>
>Adams
>deVant
>Jones
>Smith.
>
>Because of the lower case on deVant it goes to the end after all upper case items.
>
>I looked at the set commands and didn't see anything that looked it would work.
>
>Thanks
>
>Dennis