SELECT * FROM tbl_TMP_RPCOperators WHERE OperatorID = 0 INSERT INTO tbl_OPR_ClientOperators(OwnerID,FSLTableCode,CompanyName,independentYN,OPRType,OPRSegment, oprcompanytype,catering,Address,City,State,ZipCode,CountryID, AreaCode,Phone,FaxAreaCode,FaxNumber,URL,Comments, annualsales,num_units_lastYr,num_units_thisYr,num_units_nextYr, tradeclass,menulink,menucycle,menuLTO,menucomments, mfrAE,mfrTechRep,datecreated) VALUES(1,'MFR','#Left(select.CompanyName,50)#',0,'D',#select.Segment#, '1',41,'#Left(select.Address1Only,75)#','#Left(select.City,75)#','#Left(select.State,25)#','#Left(select.ZIP,10)#',27, '#Left(select.PhoneAC,3)#','#Left(select.Phone,8)#','#Left(select.FAXAC,3)#','#Left(select.FAX,8)#','#Left(variables.url,75)#','REFID=#select.REFID#', '#Left(trim(select.SSTotal),20)#','#Left(select.Units_1,20)#','#Left(select.Units_2,20)#','#Left(select.Units_3,20)#', '#Left(select.TradeClass,1)#','#Left(select.url_menu,125)#','#Left(select.menuCycle,20)#','#val(select.menuLTO)#','#Left(select.menuComments,500)#', #val(select.FSBMStaffID)#,#val(select.FSLTSStaffID)#,#CreateODBCDateTime(Now())#) SELECT max(OperatorID) AS newid FROM tbl_OPR_ClientOperators WHERE OwnerID = 1 AND FSLTableCode = 'MFR' AND CompanyName = '#Left(select.CompanyName,50)#' UPDATE tbl_TMP_RPCOperators SET OperatorID = #getMax.newid# WHERE uniqueid = #select.uniqueid# INSERT INTO tbl_RPC_PIPE_AccountPlans(OwnerID,FSL_TableCode,customerid,customertype,customername) VALUES(1,'MFR',#getMax.newid#,'OPR','#Left(select.CompanyName,50)#') ERROR: '#Left(select.CompanyName,50)#'|(#select.uniqueid#)