title: Usage on Patindex() function
body: <p>I am using <code>patindex</code> for pattern search of "MD" or "DO". The below statement returns <code>3</code>.
  Am I using it in the wrong way or is there another way of checking condition?</p>
  
  <pre><code>select PATINDEX ('%[MD,DO]%','FHoisegh MD')
  </code></pre>