title: SQL Check if a text contains a word
body: <p>I have a Text, </p>
  
  <pre><code>'Me and you against the world' // false
  'Can i have an email address'  // true
  'This is an'  // true
  'an' //true
  </code></pre>
  
  <p>I want to check whether the word <code>an</code> is inside  my String.</p>
  
  <p>How do I check if a text contains a specific word in SQL? I can't add a full-text catalog. Otherwies i could</p>
  
  <pre><code>SELECT * FROM TABLE WHERE CONTAINS(Text, 'an')
  </code></pre>