>>>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.