title: Set default value in query when value is null
body: <p>I'm running a really simple query, however for some of the results the value in one field is null. How can I set that value to "a string" if its value is null?</p>
  
  <p>Something like </p>
  
  <pre><code>SELECT RegName,
      RegEmail,
      RegPhone,
      RegOrg,
      RegCountry,
      DateReg,
      (Website IS NULL? 'no website' : Website) AS WebSite
  FROM RegTakePart
  WHERE Reject IS NULL
  </code></pre>
  
  <p>It will be running on a sql server 2005</p>
  
  <p>thanks</p>