title: SQL Query To Return Phone Number
body: <p>I have a table in SQL Server hat has:</p>
  
  <pre><code>FirstName, LastName, MiddleName, CellNumber, HomeNumber
  John Smith M 111-111-1111, 222-222-2222
  </code></pre>
  
  <p>The person can have both CellNumber and HomeNumber or can have CellNumber but no HomeNumber or can have HomeNumber and no CellNumber.</p>
  
  <p>How do i write a query that will always return CellNumber if exists and HomeNumber only if CellNumber is NULL or blank.</p>
  
  <p>SQL query to produce following results:</p>
  
  <pre><code>FirstName, LastName, MiddleName, NumberToUse, PhoneType
  John Smith M 111-111-1111 CellNumber
  </code></pre>
  
  <p>Thanks for your help.</p>