title: Is there any difference between INSTR() and CHARINDEX()?
body: <p>I was wondering if there was a difference (other than the engine compatibility and the optional occurence) between</p>
  
  <pre><code>CHARINDEX (expressionToFind ,expressionToSearch [, start_location])
  </code></pre>
  
  <p>and </p>
  
  <pre><code>INSTR (string , substring [, position [, occurrence]])
  </code></pre>
  
  <p>Thank you.</p>