title: How to write where condition for column having decimal datatype in SQL
body: <p>I have a date column which is of type "PIC S9(7) COMP-3" in IBM DB2/AS400.
  When I put these values in SQL Server, my data type of column made changed as "decimal(7,0)".This is just to making DB2 datatype similar to SQL Server.</p>
  
  <p>Now, I would like to find if there is any "space" or "numeric" in this particular date column.</p>
  
  <p>The date column is like this:</p>
  
  <pre><code> DATE
  -------
  4040404
         (a space)
  404040
  2020202
         (a space)
  202020
  </code></pre>
  
  <p>In where condition like this gives error:
        "Error converting data type varchar to numeric."</p>
  
  <pre><code> Select ID, DATE 
   from Table1
   Where DATE = ''
  </code></pre>
  
  <p>How to resolve this?</p>