Good point Dan, but computed values apply here to, don't they?
Couldn't you do: where date(datetime) between '02-01-2002' and '02-05-2002' instead of: where datetime between '02-01-2002 00:00' and '02-05-2002 23:59' *************** Of course you can do that. It is just easier to not have to. - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: [EMAIL PROTECTED] To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
