Easy Query Question

[newB11]

Please help me since I'm new and dumb. How can I take the returned values from a stored procedure and replace them with something else? I want a query that returns '1' in the 'Status' column to display 'Apples', instead, and I want it to show 'Oranges' for every instance of '2'. It should be very simple but I'm stuck. Thanks!

 

[swampBoogie]

select case status 
    when '1' then 'Apples'
    when '2' then 'Oranges'
    else 'fruit salad' end
  from t

You should be able to adapt that to your needs.