SQL returning custom values based on query results

Question

is it possible to make a query that returns a different custom value based on a query. its hard to explain, here is an example that should make it more clear.

what I have in the table:

number

• 1
• 2
• 3

here is what I want returned:

number

• one
• two
• three

something like an if statement...

Answer 1

You want a case statement. Depending on your flavor of SQL, something like this should work:

select 
    bar = case 
               when foo = 1 then 'one'
               when foo = 2 then 'two'
               else 'baz' 
          end
from myTable 

Answer 2

Try

select value = case t.value
               when 1 then 'one'
               when 2 then 'two'
               when 3 then 'three'
               ...
               else null
               end
from my_table t