Alter table 'tablename' change column 'columnname' 'new-columnname' not null default 0
If you have any null values in that column, you will not be able to make the change. J.R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]