title: t-sql substring
body: <p>I basically have one column that needs to be substringed. The format of the column looks as follow:</p>
  
  <pre><code>Column A
  --------
  Root\FOLDERPATH\somesubfolderpath\somedocument.doc
  </code></pre>
  
  <p>The first string "Root\" will always be the same lengt with same characters.  Everything after the "Root\" could vary in lenght depending on the document's folder structure.</p>
  
  <p>What I need to retrieve is the second string. Using the above example, the column should look lilke:</p>
  
  <pre><code>Column A
  --------
  FOLDERPATH
  </code></pre>
  
  <p>So I need to cut out the "Root\" obtain the string after this and cut out everything after this.</p>