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