title: How to convert nvarchar to decimal in SQL
body: <p>How to convert an nvarchar to decimal in SQL Server?</p>
  
  <p>I need to convert a value like <code>'38,716.1311'</code> to 38716.1311.</p>
  
  <p>I have tried using this method but can't successfully convert:</p>
  
  <pre><code>DECLARE @TempValue NVARCHAR(100) = '38,716.1311'
  
  SELECT 
      CONVERT(DECIMAL(18, 2), @TempValue) 
  </code></pre>
  
  <p>Can anyone suggest the correct query? Thanks in advance</p>