title: Why SQL query returns '01/01/1900' instead of an empty string when Date field is NULL?
body: <p>I'm testing some SQL query for return value.</p>
  
  <p>The table I'm selecting from has a value <code>NULL</code> in a  <code>CloseDate</code> field.
  I have a logic that checks if it is <code>NULL</code>, return an empty string. However, it returns <code>01/01/1900</code>  </p>
  
  <pre><code>declare @value varchar(50) = '2346677888'
      Set @Value=@Value +'%'
  
      select CONVERT(varchar,ISNULL(m.CloseDate,''),101) as CloseDate from( 
      SELECT m.EdsClosedDate AS CloseDate
      FROM [dbo].[tblMyTable] m                   
      WHERE MID like @value) m
  </code></pre>
  
  <p>What's wrong with the query?</p>