>>>>--You can not use EMPTY --
>>>>Thanks. You are correct. I just found it under the "Using Rushmore Query Optimzation to Speed Data Access" topic. I would think they would mention it in the EMPTY topic. Wouldn't that make sense?
>>>>
>>>>I still contend if we can figure this out based on a set of rules then the engine should be able to figure it out based on the same set of rules. Isn't that what computers are supposed to be all about? Making it easier for us!
>>>>
>>>
>>>DWIW function is not yet implemented.
>>
>>That function was a Ken's promise :-)
>
>And where is Ken now? <g>
Run out from VFPT before he keeps his promise :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.