>Have a description field with mixed case in the table. There is an index on the description field. Some descriptions are all upper, some are all lower. When I show the descriptions in a list box, upper case sorts to the sop, then lower case.
>
>Would like the list box to show the descriptions in order regardless of upper/lower case. What can I do?
>
>Thanks - Brenda
Hi Brenda,
You should use either the UPPER(), LOWER(), or PROPER() functions in the index expression.
hth,
George
Ubi caritas et amor, deus ibi est