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
Member Since 07 Apr 2006Offline Last Active Sep 08 2006 02:55 PM