title: Convert NULL datetime to Blank
body: <p>I would like to convert a datetime field to varchar so I can show a blank or a message when the date is NULL.
  This is what I have so far:</p>
  
  <pre><code>select
  isnull(us.Date,0) as USDate,
  isnull(au.Date,0) as AUDate
  from ustable us
  left join autable au
  on us.column=au.column
  </code></pre>
  
  <p>Right now this is showing: </p>
  
  <pre><code>USDATE 
  2014-10-24 10:29:07.450
  1900-01-01 00:00:00.000
  </code></pre>
  
  <p>I would like to be able to make the "1900-01-01 00:00:00.000" varchar so I can write a message or show a true blank.</p>