I have a table with
Co1 and Col2.
Col2 can have has values "AA", 'BB', and 'CC'.
I have to create a view with those two columns and it should have '01' instead of 'AA' , '02' instead of 'BB' and '03' instead of 'CC'.
How should I code it?
Thanks.

Use CASE expression.

select case col2 when 'AA' then '01' when 'BB' then '02' when 'CC' then '03' else col2 end
from table1

Kara