#form.hdnmode# INSERT INTO #Request.prefix_db_lookup#.prior_authorization ( Patient_ID, patientpayer_id, prior_authorization, start_date, end_date, HCPCS, units, covered_or_charge, Benefit_Id ) VALUES ( '#Trim(form.hdnpatientid)#', '#Trim(form.hdnpatientpayerid)#', '#Trim(form.PriorAuthorization)#', '#Trim(DateFormat(form.StartDate,'yyyy-mm-dd'))#', '#Trim(DateFormat(form.EndDate,'yyyy-mm-dd'))#', '#Trim(form.HCPCS)#', '#Trim(form.Units)#', '#Trim(form.Covered)#', '#Trim(form.Benefit)#' ) UPDATE #Request.prefix_db_lookup.prior_authorization SET Patient_ID='#Trim(form.hdnpatientid)#', prior_authorization='#Trim(form.PriorAuthorization)#', start_date='#Trim(DateFormat(form.StartDate,'yyyy-mm-dd'))#', end_date='#Trim(DateFormat(form.EndDate,'yyyy-mm-dd'))#', HCPCS='#Trim(form.HCPCS)#', units='#Trim(form.Units)#', covered_or_charge='#Trim(form.Covered)#', Benefit_Id='#Trim(form.Benefit)#' Where patientpayer_id='#Trim(form.hdnpatientpayerid)#'