BETWEEN is good, but it is doubly-inclusive meaning that it is like doing both >= and <=. In this case, it might turn up records where the created date is exactly 12:00 AM the next day.
What we need is the >= and the < (not using the equals sign in the second comparison). ...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:30 AM To: CF-Talk Subject: RE: SQL question Ben, Ok... Nicely done. What about "BETWEEN" ... Any benefits there? WHERE date_created BETWEEN @date AND @date + 1 -Mark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274430 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
