title: How do I make this SQL statement return empty strings instead of NULLS?
body: <pre><code>LastAccessed=(select max(modifydate) from scormtrackings WHERE 
  bundleid=@bundleid and userid=u.userid),
  CompletedLessons=(select Value from scormtrackings WHERE 
  bundleid=@bundleid and userid=u.userid AND param='vegas2.progress'),
  TotalLessons=100,
  TotalNumAvail=100,
  TotalNumCorrect=(SELECT Value FROM scormtrackings WHERE 
  bundleid=@bundleid AND userid=u.userid AND param='cmi.score.raw')
  </code></pre>
  <p>This is only part of a large select statement used by my ASP.NET <code>Repeater</code> that keeps crashing when the values are <code>NULL</code>, I have tried <code>ISNULL()</code> but either it didn't work, or I did it wrong.</p>
  <pre><code>ISNULL((SELECT max(modifydate) FROM scormtrackings WHERE 
  bundleid=@bundleid AND userid=u.userid),'') AS LastAccessed,
  </code></pre>
  <p><em>(...)</em></p>
  <p>???</p>
  <p>UPDATE: I've tried all these things with returning '', 0, 1, instead of the value that would be null and it still doesn't work, I wonder if the problem is with the <code>Repeater</code>?</p>
  <h3>Related Question:</h3>
  <blockquote>
  <p><a href="https://stackoverflow.com/questions/584570/why-does-my-repeater-keep-crashing-on-evalnull-values">Why does my repeater keep crashing on Eval(NULL) values?</a></p>
  </blockquote>