title: Error converting data type nvarchar to numeric - SQL Server
body: <p>I am trying to take an average of a column in my database. The column is <code>AMOUNT</code> and it is stored as <code>NVARCHAR(300),null</code>.</p>
  
  <p>When I try to convert it to a numeric value I get the following error: </p>
  
  <blockquote>
    <p>Msg 8114, Level 16, State 5, Line 1<br>
    Error converting datatype NVARCHAR to NUMBER</p>
  </blockquote>
  
  <p>Here is what I have right now. </p>
  
  <pre><code>SELECT AVG(CAST(Reimbursement AS DECIMAL(18,2)) AS Amount
  FROM Database
  WHERE ISNUMERIC(Reimbursement) = 1 
    AND Reimbursement IS NOT NULL
  </code></pre>