title: IS NULL doesn't work
body: <p>I have a table like the one above with the two left columns (Both of them are integer) and I added to this table two more fields: </p>
  
  <p>Table1:</p>
  
  <pre><code>Asset_Value    Contract_Value  
  -------------------------------
  0              NULL             
  NULL           200               
  0              NULL     
  </code></pre>
  
  <p>And the query: </p>
  
  <pre><code>Select 
      Asset_Value, Contract_Value,
      Case 
         when Asset_Value is null 
            then 1 
            else 0 
      end As Ind_ForNullA,
      Case 
         when Contract_Value is null
            then 1 
            else 0 
      end As IndForNullC
  from 
      table1
  </code></pre>
  
  <p>However, I get strange results: </p>
  
  <pre><code>Asset_Value Contract_Value  Ind_ForNullA IndForNullC
  ----------------------------------------------------
  0              NULL              1            1
  NULL           200               0            0
  0              NULL              0            1
  </code></pre>
  
  <p>Update : Never Mind. Damm comma has been forgetten. </p>