title: How to get substring from given character?
body: <p>I have table with logins in this form:  </p>
  
  <pre>login1  
  domain1\login2  
  otherDomain\login3</pre>
  
  <p>Data is always in form:<br>
  DOMAIN\login<br>
  or<br>
  login  </p>
  
  <p>I need to retrieve user logins without prefixes in form (leave everything on right side of '\'):  </p>
  
  <pre>login1  
  login2  
  login3</pre> 
  
  <p>How to do that in SQL Server?</p>