title: SQL Server Equivalent to ORACLE INSTR
body: <p>I wanted to know if in SQL Server there is an equivalent to the Oracle <code>INSTR</code> function?<br>
  I know that there is <code>CHARINDEX</code> and <code>PATINDEX</code>, but with the Oracle version I can also specify the Nth appearance of the character(s) I am looking for.</p>
  
  <blockquote>
    <p>Oracle <code>INSTR</code>: </p>
  
  <pre><code>instr( string1, string2 [, start_position [, **nth_appearance** ] ] )
  </code></pre>
  </blockquote>
  
  <p>The <code>CHARINDEX</code> almost gets me there, but I wanted to have it start at the <strong><code>nth_appearance</code></strong> of the character in the string.</p>