Hi, I needed to repair some data that had been entered inconsistently, I was in a rush so I did it manually via SqlYOG. (too much of a rush to consider how to do it quickly!)
The bad data in one column propertyID was of kind \w\w\w\d eg ONE1 \w\w\w\d\d eg ABC23 \w\w\w\d\d\d eg FGH123 when they all needed to packed with zeros as necessary \w\w\w\d\d\d\d so ONE1 -> ONE0001 ABC23 -> ABC0023 FGH123 -> FGH0123 What Update Query should/could I have used? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]