here's my script
<pomoddata>
<Scripts>
<script>insert into POMOD_Q2ODATA (moc_id,id,DocID,OriginalSalesOrderNumber,ChapterID,ChapterNumber,BookingType,Qty,ProductNumber,ProductDescription,NetPrice,LineItem,SalesOrderNumber,POMODCreatedDate,POMODCompletedDate) values('V4C20120228084130HP53','201560','208427','6301123146','140944','001000','Product Cancellation','2','M1943AL','Sp02 8-pin D-sub Adapter cable 3m (8pin)','-225.68','','','2012-05-21 10:18:06.67','2012-06-18 09:54:53.45')
</script>
</Scripts>
</pomoddata>
I want to remove parenteses in Product Description value of my insert query "Sp02 8-pin D-sub Adapter cable 3m
(8pin)" because in access database it's not allowing to insert data with parenteses.Can anyone please help me in this topic ?