title: SQL 'LIKE' clause with apostrophe
body: <p>If im trying to search for 'RYAN'S TEAM' in sql it doesnt like the fact that i have an apostrophe ' in RYAN'S and detects that as the end of the LIKE statement.</p>
  
  <pre><code>    [Team] LIKE '%RYAN'S TEAM%' 
  </code></pre>
  
  <p>It recognises the whole next line as red in sql server. Is there anyway around this as RYAN'S TEAM is the way it is stored in the database.</p>