title: How to insert empty string (' ') to decimal or numeric in SQL Server?
body: <p>Is there a way to insert an empty string (' ') into a column of type <code>decimal</code>?</p>
  
  <p>This is for the example :</p>
  
  <pre><code>create table #temp_table 
  (
      id varchar(8) NULL,
      model varchar(20) NULL,
      Plandate date NULL,
      plan_qty decimal (18, 0) NULL,
      Remark varchar (50) NULL,
  )
  
  insert into #temp_table (id, model, Plandate, plan_qty, Remark)
  values ('pn-01', 'model-01', '2017-04-01', '', 'Fresh And Manual')
  </code></pre>
  
  <p>I get an error </p>
  
  <blockquote>
    <p>Error converting data type varchar to numeric.</p>
  </blockquote>
  
  <p>My data is from an Excel file and has some blank cells.</p>
  
  <p>My query read that as an empty string.</p>
  
  <p>If there is a way, please help.</p>
  
  <p>Thanks</p>