title: SQL INSERT Query with String variable in it
body: <p>I have an SQL query in which I need to insert a string variable but I am getting errors from it.</p>
  
  <p>Below is my SQL INSERT query:</p>
  
  <pre><code>Insert into User(Employee, Name, Address, Role, Action) 
  Select distinct ur1.Employee, ur1.Name, ur1.Address, ur1.Role, ['%" + action + "%'] as [Action] FROM UserRoles ur1)";
  
  string action="insert delete query in database"
  </code></pre>
  
  <p>I would like to insert <em>string</em> <code>action</code> into my <code>INSERT</code> statement, but I am getting lots of syntax errors.</p>
  
  <p>Can anyone help me with the query?</p>
  
  <p>Thank you in advance for any help.</p>