Hi, Everyone.. I have a big trouble maintaining fields in Oracle, My Case is : in one field 's_misc' it contains value with "()" separation: (Name)(Address)(Proffesion) Then i want to separate this value to another column to s_name s_address s_proffesion How Can it be? Thanks... -- Hendri 'cacem' Hobbys Programmer MCP (Microsoft Certified Pirate) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php