scatter memvar perform alltrim manipulations when needed TEXT TO insertSImain NOSHOW PRETEXT 15 TEXTMERGE Insert Into webprddt7.qasimast(recseq, insptype, docno, partno, shipsetid, dwgrev, vendorcode, faiindex, lotqty, sampletype, sampleqty, accptdqty, rejdqty, inspdate, inspector, inspsource, rejtindex) VALUES (?x,1, ?m.docno, ?m.partno, ?ALLTRIM(testconnQuery.jobno), ?ALLTRIM(testconnQuery.revision), ?ALLTRIM(testconnQuery.vendorcode), ?testconnQuery.faiindex, ?testconnQuery.lotsize, ?testconnQuery.sampletype, ?testconnQuery.cmss, ?testconnQuery.cmaa, ?m.cmar, ?m..inspectdt, ?m.inspectsna,1, ? y) ENDTEXT ? insertSImain If SQLEXEC(testconn, insertSImain) <> -1 Then =SQLCOMMIT(testconn) ELSE If Aerror(odbcerrormsg) > 0 Then MessageBox(odbcerrormsg(2)) EndIf EndIF* Make extra needed changes