title: SQL Like Clause with escape single quote
body: <p>Hi I am trying to run this query in SQL  but it is not giving me the result :</p>
  
  <pre><code>SELECT        COUNT(*) AS Expr1
  FROM            restaurantData
  WHERE        (restaurantInfo LIKE '''%' + 'xyz' + '%''') OR
                           (restaurantName LIKE '''%' + 'xyz' + '%''') OR
                           (restaurantDescription LIKE '''%' + 'xyz' + '%''')
  </code></pre>
  
  <p>I have restaurantName column with value xyz Restaurant</p>
  
  <p>Here is some sample data</p>