title: How to convert NVarchar to Decimal?
body: <p>I have a column as nvarchar(max) whose value is </p>
  
  <pre><code>'1.7925e+006'
  </code></pre>
  
  <p>How can this be converted to decimal? I have tried as below </p>
  
  <pre><code>declare @pd as nvarchar(max) = '1.7925e+006'
  Select convert(decimal(18, 2), @pd)
  </code></pre>
  
  <p>but I get an erorr:</p>
  
  <blockquote>
    <p>Msg 8114, Level 16, State 5, Line 4<br>
    Error converting data type nvarchar to numeric.</p>
  </blockquote>
  
  <p>Please suggest.</p>