title: Converting SQL Server null date/time fields
body: <p>Whenever the value is null for this query</p>
  
  <pre><code>SELECT ISNULL(someDateTime,'')
  FROM  someTable
  </code></pre>
  
  <p>the result is</p>
  
  <pre>someDateTime  
  ------------
  1900-01-01 00:00:00.000
  </pre>
  
  <p>I want it to be "No", so if I run this:</p>
  
  <pre><code>SELECT ISNULL(someDateTime,'No')
  FROM  someTable
  </code></pre>
  
  <p>then there's this error: </p>
  
  <blockquote>
    <p>Conversion failed when converting datetime from character string.</p>
  </blockquote>
  
  <p>How to do it?  Thanks in advance!</p>