title: How to use Isnumeric in dynamic sql?
body: <p>I need to know how to fetch the numerical values from the outputformula column which is in varchar datatype.</p>
  
  <p>I use this outputformula column in a dynamic sql query to perform mathematical calculations.</p>
  
  <p>I have the below code for the table and the select query to fetch the values.</p>
  
  <pre><code>Create table #table1
  (
  IDNUM  int,
  outputformula  varchar(60)
  )
  
  insert into #table1
  values 
  (1, '67349.000 +78343.000'),
  (2, 'a +78343.000'),
  (3, '45783.00+b'),
  (4, '6152.000 +1524.000'),
  (5, 'cda +7151.000'),
  (6, '67349.000 +78343.000')
  
      Select outputformula from #table1 where ISNUMERIC(outputformula) =1
  </code></pre>
  
  <p>When I execute the code I get no values is there a way to get the output of only the numerical values apart from the alphabets in the column....</p>
  
  <p>I should get the output column as </p>
  
  <pre><code> 67349.000 +78343.000
   6152.000 +1524.000
   67349.000 +78343.000
  </code></pre>