Friday, March 28, 2003, 12:56:19 PM, you wrote: PR> The problem is I cannot find a function that allows me to perform PR> comparisons against the datetime value in the varchar field. (basically PR> an aggregate function within a where clause)
Look into the Cast or Convert functions, as described in the mySQL manual here: http://www.mysql.com/doc/en/Cast_Functions.html Brent -- BrentO Famous Last Words #7: "You and what army?" To unsubscribe from a list, send a mail message to [EMAIL PROTECTED] With the following in the body of the message: unsubscribe SAlive
