INSERT iGNORE INTO #Request.prefix_db_lookup#.Meds_New ( Name,Uses, Contraindications, Administration, Interactions,Side_Effects, Teach, Trade_Name, Generic_Name, Classification,Grouping ) VALUES ( '#Trim(form.Name)#', '#Trim(form.Uses)#','#Trim(form.Contraindications)#','#Trim(form.Administration)#','#Trim(form.Interactions)#', '#Trim(form.Side_Effects)#','#Trim(form.Teach)#','#Trim(form.Trade_Name)#','#Trim(form.Generic_Name)#','#Trim(form.Classification)#', '#Trim(form.Grouping)#' ) UPDATE IGNORE #Request.prefix_db_lookup#.Meds_New SET Name = '#Trim(form.Name)#', Uses = = '#Trim(form.Uses)#', Contraindications = '#Trim(form.Contraindications)#', Administration = '#Trim(form.Administration)#', Interactions = '#Trim(form.Interactions)#', Side_Effects = '#Trim(form.Side_Effects)#', Teach = '#Trim(form.Teach)#', Trade_Name = '#Trim(form.Trade_Name)#', Generic_Name = '#Trim(form.Generic_Name)#', Classification = '#Trim(form.Classification)#', Grouping = '#Trim(form.Grouping)#' WHERE Trade_ID = '#Form.ID#'