title: How to Concat String in SQL WHERE clause
body: <p>I have declared two variables in RAW sql</p>
  
  <pre><code>DECLARE @str nvarchar(max), @str1 nvarchar (max);
  
  SET @str = "  AND (c.BondSales_Confirmed &lt;&gt; -1)";
  
  SET @str1 = "  AND (c.BondSales_IssueType = 'REGULAR')";
  </code></pre>
  
  <p>My SQL query is:</p>
  
  <pre><code>SELECT * From t_BondSales Where (BondSales_cType &lt;&gt; 'Institute') " + str1 + str  "
  </code></pre>
  
  <p>Here I get the following error: </p>
  
  <blockquote>
    <p>Error: SQL Problems: Incorrect Syntax near  "+ str1 + str"</p>
  </blockquote>
  
  <p>Can any one  Please help me with the proper syntax about how to concat String in where clause?</p>