title: how to catch NULL values using case statement
body: <p>here in this query I want to replace the values in Person.Contact of Adventureworks database with some new values. The below query case statement is working fine for other values but I am not able to change the values those are in NULL. I am using SQL Server. Any help is appreciated.</p>
  
  <pre>
  select contactid,Title,FirstName,MiddleName,
  case MiddleName
  when 'R.' then 'Robert'
  when 'B.' then 'Bids'
  when 'J.' then 'John'
  when is null then 'New Name'
  else 'No Name'
  end, LastName from Person.Contact
  </pre>