title: How to split a string after specific character in SQL Server
body: <p>I am working in SQL Server studio manager 2014</p>
  
  <p>I found this and it is sort of close to what I am wanting, but not quite perfect. </p>
  
  <pre><code>Col2 = RIGHT([HospCode],LEN([HospCode])-CHARINDEX('.',[HospCode]))
  </code></pre>
  
  <p>My data looks like this</p>
  
  <p>ABC.FRED.123<br>
  ABC.STEVE<br>
  ABC.SUSAN<br>
  ABC.TED.4456<br>
  ABC.WILL<br>
  ABC.TABITHA.11<br>
  ABC.TODD<br></p>
  
  <p>I want to get rid of the "ABC." and the ".xxx" number section IF it exists and only see the Name section. So I want my final output to be something like: <br><br> </p>
  
  <p>FRED<br>STEVE<br>SUSAN<br>TED<br>WILL<br>TABITHA<br>TODD</p>
  
  <p>Can anyone assist? Thank you in advance!</p>