title: How to split string by forward slash in SQL Server?
body: <p>There is no default split function in SQL Server 2012 that I'm using.</p>
  
  <p>I want to split the string (ex: <code>/Folder1/Folder2/</code>) by <code>/</code>.</p>
  
  <ul>
  <li>if string is <code>/Folder1/</code> then output should be <code>Folder1</code>,</li>
  <li>if string is <code>/Folder1/Folder2/</code> then output should be <code>Folder2</code>,</li>
  <li>if string is <code>/Folder1/Folder2/Folder3/</code> then output should be <code>Folder3</code>.</li>
  </ul>