title: SQLServer DATETIME conversion to STRING if NULL
body: <p>my datetime column (type=datetime) in my DB is as follows</p>
  
  <p><img src="https://i.stack.imgur.com/bs95T.png" alt="enter image description here"></p>
  
  <p>why is this statement not converting the '1900-01-01 00:00:00.000' values to 'date not set'</p>
  
  <pre><code>ISNULL(
     CASE WHEN CONVERT(VARCHAR, [TB].Date) = '1900-01-01 00:00:00.000' 
     THEN 'date not set' 
     ELSE CONVERT(DATE, [TB].Date, 25) 
     END, '') AS Xdate,
  </code></pre>
  
  <p>What am i missing?</p>
  
  <p>Cheers
  Paul</p>