Well, after some investigation. I came up with an answer. It appears the UPPER command is used in the index (when it was created). You can use the following sql query and it uses the index:
select order from cms where UPPER(alt_order) = '323771'
-Lockley Gentes/WorshipMusic.com
Lockley's Content
There have been 2 items by Lockley (Search limited from 08-May 23)