Hi,
I have a column which has numbers 1, 2, 3. I want to replace the value in this column.
Say if its 1 then replace it by 'one' , 2 then replace it by 'two'. And i want to do this in a select statement. I dont want it be changed in my table. i need this change only in my result set.
Thanks,
Ashu