title: how to cast nvarchar to decimal?
body: <p>i know how to convert nvarchar to decimal(18,4) Cast method. my tables rows count 80000. My query run perfect below...   </p>
  
  <pre><code>
  SELECT  top 80000 id, Cast(MH as decimal(18,4)) as MH 
  FROM TaskRelations WHERE MH is not null
  </code></pre>
  
  <p>BUT;</p>
  
  <p> but below select query not WORK! if write below:</p>
  
  <pre><code>
  SELECT   id, Cast(MH as decimal(18,4)) as MH 
  FROM TaskRelations WHERE MH is not null
  </code></pre>
  
  <p>ERROR: Error converting data type nvarchar to numeric.
   </p>