title: SQL Adding a column to a table, with case statement
body: <p><em>I have my case statement but would like to add the new column "Unit_Type" to the table...</em></p>
  
  <pre><code>Unit_type =(case [INSP_UNIT_TYPE_ID] 
      when '9' then 'Semi Trailer'
      when '7' then 'Pole Trailer'
      when '6' then 'Other'
      when '5' then 'Motor Carrier'
      when '3' then 'Full Trailer'
      when '2' then 'Dolly Converter'
      when '14' then 'Intermodal Chassis'
      when '12' then 'Van'
      when '11' then 'Truck Tractor'
      when '10' then 'Straight Truck'
      else 'Invalid'
          end)    from [dbo].[Insp_Unit_Pub_01012015_05282015];   
  </code></pre>