>>This strikes me as being inefficient, since the
DTOC() and STR() functions would need to be run on the column data, and I am wondering if you can do this another way.
>>
>>Thanks
>
>As Nick noted, you have to convert them all to be string. But I would use DTOS() not DTOC() so that you're dates will be ordered correctly, no matter what the format is.
Thanks, guys.
I was hoping that I had missed something somewhere.
Hey, Fred, thanks for pointing me to another VFP function DTOS(). I had not ever seen that one. What's interesting is that DTOC has an optional number parameter that states it is for maintaining index expressions (the optional [,1]). DTOS() is quicker to type, if nothing else. Now, on to other things:
I understand that I would have to be careful composing scope clauses, etc., in order for RUSHMORE to kick in and use that compound index...
Jim Newsom
IT Director, ICG Inc.