title: Sql Server -- Strip off non numeric characters
body: <p>I have a table</p>
  
  <pre><code>SET ANSI_NULLS ON
  GO
  
  SET QUOTED_IDENTIFIER ON
  GO
  
  CREATE TABLE [dbo].[TestAB](
      [A] [int] IDENTITY(1,1) NOT NULL,
      [B] [nvarchar](10) NULL,
   CONSTRAINT [PK_TestAB] PRIMARY KEY CLUSTERED 
  (
      [A] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  
  GO
  </code></pre>
  
  <p>Values Like</p>
  
  <pre><code>INSERT INTO [TestAB]([B]) 
      VALUES('A1');
  
  INSERT INTO [TestAB]([B]) 
      VALUES('A2');
  
  INSERT INTO [TestAB]([B]) 
      VALUES('A5');
  
  INSERT INTO [TestAB]([B]) 
      VALUES('A4');
  
  INSERT INTO [TestAB]([B]) 
      VALUES('AA5');
  
  INSERT INTO [TestAB]([B]) 
      VALUES('A9');
  
  INSERT INTO [TestAB]([B]) 
      VALUES('C7');
  
  INSERT INTO [TestAB]([B]) 
      VALUES('D8');
  
  INSERT INTO [TestAB]([B]) 
      VALUES('D-9');
  
  INSERT INTO [TestAB]([B]) 
      VALUES('R$10');
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/YKYCU.png" alt="Table Select"></p>
  
  <p><img src="https://i.stack.imgur.com/Zkh9c.png" alt="Table Design"></p>
  
  <p>I want to strip off the non numeric characters and cast the nvarchar numbers to int and then compare where they are !=</p>