title: SQL Server 2008 - Strip numbers from start of string
body: <p>I am using SQL Server 2008,</p>
  
  <p>I have a table called locals which has records as follows:-</p>
  
  <pre>447455 -    1 ABERCORN COTTAGES
  447456 -    12 ACACIA WALK
  447457 -    13 ACTON HILL STUDIOS
  447458 -    21 ADELAIDE COTTAGES
  447459 -    321 ALBERT COTTAGES
  456155 -    722 CLIVE COURT</pre>
  
  <p>What I want to do is remove all the numbers in the 'Street' column (maybe using REPLACE) so the records update to:-</p>
  
  <pre>447455 -   ABERCORN COTTAGES
  447456  - ACACIA WALK
  447457  - ACTON HILL STUDIOS
  447458 -    ADELAIDE COTTAGES
  447459 -    ALBERT COTTAGES
  456155 -    CLIVE COURT</pre>
  
  <p>I have tried:-</p>
  
  <pre><code>UPDATE LOCALS 
  SET Street = REPLACE (REPLACE (REPLACE (REPLACE (REPLACE (REPLACE (REPLACE (REPLACE (REPLACE (REPLACE (str(50), '0', ''), '1', ''), '2', ''), '3', ''), '4', ''), '5', ''), '6', ''), '7', ''), '8', ''), '9', '') 
  where AtoZIndex &gt; '447454' 
    and AtoZIndex &lt; '457309'
  </code></pre>
  
  <p>The street column is <code>NVARCHAR(50)</code></p>
  
  <p>But this just made all the records blank, any suggestions on how I could fix this?</p>