title: How to De-Concatenate a Field
body: <p>I have a field in our SQL Server database that is basically two fields concatenated together.  It has a descriptor and a number.  I want to build a view with just the number so that I can relate it to other tables.  The number is actually typed as a nvarchar on the other tables.  So from data like this I want to query for just the number portion:</p>
  
  <p>ProgramField with values:</p>
  
  <pre><code>tst_desc:1
  tst_desc:124
  tst_desc:1495
  tst_desc:20483
  </code></pre>
  
  <p>So I'd like my query to return a result of:</p>
  
  <p>ProgramNumField</p>
  
  <pre><code>1
  124
  1495
  20483
  </code></pre>
  
  <p>The number is variable in length growing over time and needs to be nvarchar so I can relate it to the other tables in the database.</p>
  
  <p><a href="https://i.stack.imgur.com/ND4Cl.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ND4Cl.jpg" alt="enter image description here"></a></p>