>Yeah, we could play with ANSI and EXACT, but probably easier just to clean up our data and indexes so as not to need these long, compound expressions (I prefer to only have single fields indexed and control everything with SELECT statements).

Smart choice. The compound index keys are VFP specific whereas SELECT with indexes on separate fields will work with other backends if neccesary.