insert into mytable ( ... , mydatecol, ... ) values ( ... , str_to_date('3/MAY/07','%e/%M/%y'), ... ) rudy http://r937.com/