I have several tables with long numbers whose digits are always in some multiple of 8 eg 00000000 or 0000000000000000 etc...up to 160 digits long. The numbers all have a number of digits that is some multiple of 8. What I need to do is write an sql update query that will insert a - or some other seperator character every 8 digits in cases where the number of digits is higher than 8 i.e. 00000000-00000000, and so on for bigger numbers. What query would i use to do this?
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php