title: Error converting varchar to numeric with MSSQL
body: <p>Query</p>
  
  <pre><code>SELECT TOP 1000
  CASE WHEN VRI.Square_Footage &lt;&gt; '' 
  THEN VRI.Square_Footage 
  ELSE 
      CASE WHEN VRI.Property_Type = 'LAND' 
          THEN CAST((CONVERT(NUMERIC(38, 3),VRI.Acres)*43560) AS DECIMAL) 
      ELSE 
          VRI.Lot_Size 
      END 
  END
  FROM View_Report_Information_Tables AS VRI
  </code></pre>
  
  <p>Even if I checked for <code>VRI.Acres</code> with <code>isnumeric()</code>, it still yield the same exact error? How can I fix this problem?</p>