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