> I tried your replace(left()) (as is, just changed the fieldname) on a > datetime and it certainly works fine on mySQL 3.23.53-max-nt on Win2k.
It worked for me too on Mysql 4 - WIN2k, but I can't see anything else that could be causing the problem. Cheers Mark ______________ Mark Stanton Web Production Gruden Pty Ltd Tel: 9956 6388 Mob: 0410 458 201 Fax: 9956 8433 www.gruden.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
