Hi am new into using navicat and i have two tables namely tbserver and tbservercomp i.e tbserver contains a column called memo having (2439(1),7872(4)) where the first 4 digits are part number and the one i bracket is the quantity ....i have to create a php file that will select the component in the memo collumn seperate the characters and fix them as follows in tbservercomp column component that will have the component number i.e 2439 and collumn quantity will have 1 as the quantity my db is called nts plizz assist