Yeah, it works if your time is midnight, but that's it. Any other time does *not* get selected.

~~Bonnie

>>>>Bonnie that is a great point. I just wish I could simply use Like '2004-05-04%' :(
>>>
>>>Try this format '20040504'. SQL seems to have no problem with that.
>>
>>You sure about that Fred? I can't get that to work.
>>
>>~~Bonnie
>
>I do it all the time.
>
>

>SELECT * FROM tblMain WHERE DateTimeField='20040504'
>

>
>If you try this from Enterprise Manager, it complains about the date format, but the SELECT works just fine. Works in SPT from VFP, and I've done a couple of C# programs that use it just fine.