How can change retrieved data in storedProcedure

[tomach]

Hello,

I have a small problem,

I have table:

data
-------
id | er|
----------
1 | 4|
2| 5|

I would like to retrevied this data, which is simply easy
select * from data,

but at the same time i would lket to change er values to strings : 4= OK, 5=BAD , that the query would return :

data
-------
id | er|
----------
1 | OK|
2| BAD|

but database would stay unchanged...

any ideas? is it possible at all?

[debasisdas]

Question moved to SQL Server forum

[debasisdas]

use CASE statment for the purpose.

[iburyak]

Try this:


select id,
case when er = 4 then 'OK'
when er = 5 then 'BAD'
else ''
End ER
from data