Value substitution

[gixer]

Hi,

I'm trying to do a simple query with a value substitution.

In the table the value 'yes' is stored as an integer of 1 and the value 'no' is stored as an integer of 2.

select responded from test

If you run the query above here are the results:

responded
---------
1
2
1
1

How would I write the query so it would return the following results:

responded
---------
yes
no
yes
yes

Thanks for any help!!

 

[sunila7]

Hi,

Try this........

Select CASE responded when 1 then 'Yes' Else 2 END From TBL

Hope it helps
Sunil

 

[gixer]

Thanks Sunil.

One more question. How do you do a column alias with a case statement?

 

[gixer]

Got it. END as columnalias