At 03:44 PM 6/19/2003 -0400, you wrote: >I'm having trouble returning records that match a specific date. > >SELECT * FROM myTable >WHERE myDate = '5/7/2003'
Do it where you search between your date at 00:00:01 and your date at 23:59:59. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Get the mailserver that powers this list at http://www.coolfusion.com
