var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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?
Use CASE expression.
select case col2 when 'AA' then '01' when 'BB' then '02' when 'CC' then '03' else col2 end
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors