UPDATE my_table SET my_column = TRIM(my_column), my_other_column = TRIM(my_other_column)
etc... Dave Merrill > Is it possible to remove all trailing and leading spaces for selected > fields once the data has already been loaded? > > Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]