query help 1

[mikedaruke]

Hi, I have a col in a table that has numbers, 1 = Real, 2 = Fake, etc.

when I do the query, instead of it showing 1, 2 can it show Real, Fake?

How do you do that

 

[Dagon]

Use a decode statment:

select decode(column, 1, 'Real', 2, 'Fake') from table

 

[mikedaruke]

Thanks for the quick response. This is exactly what I needed. Thanks!

 

[SantaMufasa]

Thanks for the quick response. This is exactly what I needed. Thanks!

At this point, Mike, we Tek-Tipsters typically press the link, Thank Dagon for this valuable post to give Dagon a well-deserved

.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[SantaMufasa]

Dagon,

Since Mike seems to be Missing In Action, please accept a

in his behalf, from me.

Cheers,

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]