If I understand your problem, MySQL allows you to use regular expressions - so you could use the REGEXP function to remove the spaces. Check out the mysql site...
Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]