Hello,

is there a way to give the DECODE function a range of values as the second parameter instead of just one value?

this is what i am doing right now:

DECODE (patient_age, '1', 'less than 15', '2', 'less than 15')etc....

I would like to do : if age is between 1 and 15 , then "less than 15'

Any help, hints would be appreciated!
Thank you