Jump to content


Lockley

Member Since 07 Apr 2006
Offline Last Active Sep 08 2006 02:55 PM
-----

Posts I've Made

In Topic: Foxpro indexes not working when accessing through ODBC

07 April 2006 - 11:38 AM

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