title: SQL text before the Nth match?
body: <p>Using SQL I'd like to return all text before the 3rd forward slash in a column</p>
  
  <p>so</p>
  
  <pre><code>/one/two/three/whatever/testing
  </code></pre>
  
  <p>would return:</p>
  
  <pre><code>/one/two/three
  </code></pre>
  
  <p>Any quick and dirty way to do this in SQL (specifically MS T-SQL under MS SQL 2005+) ?</p>