* Paul DuBois [...] > >Jan 02, 2004 [...] > By the way, why do you have MID(datecol,8) rather than MID(datecol,9)?
There was no comma in the dates in his original post. He should use MID(datecol,9) if there actually is a comma in his dates, though MID(datecol,8) will also work in this case because of the space preceeding the year. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
