title: Splitting value of a varchar column into two columns
body: <p>If I have a column in which strings vary in length but they ALL have a slash <code>\</code> within,
  how can I SELECT to have one column display everything BEFORE the <code>\</code> and another column displaying everything AFTER the <code>\</code>? </p>
  
  <pre><code>name         column1     column2
  DB5697\DEV   DB5697      DEV
  </code></pre>
  
  <p>I have seen <code>CHARINDEX</code> and <code>REVERSE</code> on MSDN but haven't been able to put together a soltuion.</p>
  
  <p>How can I best split a varchar/string column value into 2 columns in a result set in TSQL ?</p>