strSQL.AppendFormat("DELETE EventTargets WHERE EventID = {0}\n", e.Keys["EventID"]); foreach (ListItem Item in lsbTargets.Items) { if (Item.Selected) { strSQL.AppendFormat("INSERT INTO EventTargets VALUES({0},'{1}')\n", e.Keys["EventID"], Item.Value); } }However, I see DELETE EventTargets where EventID=32INSERT... in the debugger. So, apparently my guess that \n is supposed to be CRLF is wrong.