title: SQL Server 2008 - Set a value when the column is null
body: <p>I'm doing a SELECT statement on a SQL Server 2008 database.</p>
  
  <pre><code>SELECT Name, DOB, Address1, Address2, City, State, Zip
  FROM Users
  </code></pre>
  
  <p>However, if any of the above columns happen to be empty for a specific row, I want to put the value <code>NA</code> in the column.</p>
  
  <p>Normally this would return:</p>
  
  <pre><code>SMITH^JOHN, 1/1/1980, 5140 N 1ST ST, NULL, NOWHERE, WA, 98221
  DOE^JANE, 5/5/1970, NULL, NULL, NULL, NULL, NULL
  </code></pre>
  
  <p>What I want to be returned is:</p>
  
  <pre><code>SMITH^JOHN, 1/1/1980, 5140 N 1ST ST, NA, NOWHERE, WA, 98221
  DOE^JANE, 5/5/1970, NA, NA, NA, NA, NA
  </code></pre>
  
  <p>However, I don't want to actually update the database. I just want the <code>SELECT</code> statement to return this static value whenever the result is <code>NULL</code>.</p>