title: Incorrect SQL Syntax - Unclosed quotation mark after the character string
body: <p>Now i have string <code>a = "Unclosed quotation mark after the character string '%Bamboo.Widgets.RequestApproval.CollectTask   ORDER BY Date DESC'.  Incorrect syntax near '%Bamboo.Widgets.RequestApproval.CollectTask   ORDER BY Date DESC'."</code> for filter </p>
  
  <p>I'm using replace ("'","''") 
            replace ("%","[%]")
            replace ("[","[[]")</p>
  
  <p>and I have as a result for string strSQL = </p>
  
  <pre><code>select * from studiologs 
  where [Message] 
  like '%Unclosed quotation mark after the character string ''%Bamboo.Widgets.RequestApproval.CollectTask   ORDER BY Date DESC''.  Incorrect syntax near ''%Bamboo.Widgets.RequestApproval.CollectTask   ORDER BY Date DESC''.%'
  </code></pre>
  
  <p>but result always is null 
  please help me replace this string for filter </p>
  
  <p>thanks all</p>