> 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 $elements = explode(')(',substr($s_misc,1,-1)); That'll give you each of the values inside of the parenthesis in an array. This is after you pull the value out of oracle, btw. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php