title: Parse characters in SQL Server 2008
body: <p>I have a SQL column with name txt_Full_Path which has data as given below</p>
  
  <pre><code>E:/My_Users//kpa1/eOReport - VSD.mrk 
  E:/My_Users//krishr9/Report.mrk 
  E:/My_Users//kristc/AllPAS.mrk 
  E:/My_Users//kukerm/v1.mrk      
  E:/My_Users//ksnedike/abcdef.mrk
  </code></pre>
  
  <p>how do I get the value after first occurrence of '//' moving from left to right?</p>
  
  <p>so that I get these values in a new column.</p>
  
  <pre><code>kpa1
  krishr9
  kristc
  kukerm
  ksnedike
  </code></pre>