title: How to remove the 1st character from a column in SQL Server
body: <p>I have a Table, Table A, and in table A I have Field A. There are values in field A like the following:</p>
  
  <pre><code>Street A
  Street B
  ,Street C
  Street D
  etc
  </code></pre>
  
  <p>I would like to know if there is any SQL that will allow me to either remove the 1st character  from Field A where there is a ,. </p>
  
  <p>I have know idea where to start I can select all the rows which have a , in Field A but I don't know where to start when trying to remove it.</p>