title: Extract characters to the right of a delimited value in a SELECT statement
body: <p>I need to extract all the characters to the right of a hyphen as part of a select statement. There will be other columns in the select. In the below query, the right three characters are selected from the second column. How would I extract an indefinite number of characters to the right of a delimiter – in my case a hyphen? Can I use the right function? Do I need to use another function?</p>
  
  <pre><code>Select column1, right(column2,3) as extracted, column3
  From myTable
  </code></pre>
  
  <p>I am using SQL Server 2008.</p>