title: How to I search for a single quote character( ' ) in a text Using LIKE predicate in SQL Server
body: <p>I want to search and select columns where there is a single quote (') present in the text using LIKE or CONTAINS Predicate.</p>
  
  <p>consider the following text : 10011-RIO MARE EXTRA'</p>