title: T-SQL - trim leading characters
body: <p>I have a column (<code>nvarchar(255)</code>) and I'm looking to trim, to just display the name</p>
  
  <p>Input</p>
  
  <pre><code>22;#Simon Smith
  103;#John Doe
  34;#Sarah Jones
  1;#Robert Snow
  ...
  </code></pre>
  
  <p>Output Required</p>
  
  <pre><code>Simon Smith
  John Doe
  Sarah Jones
  Robert Snow
  </code></pre>