Fred,

I don't think the VFP datetime() function will return millisecond level information. C/C++ functions can, SQL server can.

>Sounds reasonable to me. But I thought that DATETIME() did return a millisecond value, you just didn't see it, and that's what would cause problems in trying to do a SELECT for a specific datetime type value.