Decode Funcion Help

[elwayisgod]

Hi,

I need to write a decode on a field 'MCO'. If the zip code is between 00000 and 14999 then MCO = 413, if zipcode is between 15000 and 39999 then MCO = 414... and so on.. How do I do this?

Thanks

 

[keypulse1]

elwayisgod

Is Decode for 'MCO' in the Query or Results Section? If Query what Database? If results have you looked at Switch Case?

Regards

Wayne Van Sluys
KeyPulse, Inc.

 

[tallbarb]

Couldn't you use the substring function in a new, computed column that tests for the value of the MCO item?

if (Substr(MCO, 1, 5) <= 14999)
413;
else
if (Substr(MCO, 1, 5) >= 15000)
414;
else

and so on......