title: Apply IsNull function on a date column (SQL Server)
body: <p>I am trying to apply the <code>IsNull</code> function to a column of a datatype <code>date</code>.
  What am trying to do is, to replace the word <code>NULL</code> with an empty string (actual null value) when retrieving the data  </p>
  
  <p>The code am using is; </p>
  
  <pre><code>Select 
      ISNULL("UPDATE_DT", '')
  from 
      MyTable
  </code></pre>
  
  <p>I have also tried </p>
  
  <pre><code>Select 
      ISNULL("UPDATE_DT", 0)
  from 
      MyTable
  </code></pre>
  
  <p>The error am getting is </p>
  
  <blockquote>
    <p>Msg 103010, Level 16, State 1, Line 1<br>
    Parse error at line: 4, column: 1: Incorrect syntax near 'from'.</p>
  </blockquote>