I'm trying to order the days of the week by day (Sunday-Saturday), I keep getting it in alphabetical order. I'm trying to use a decode function as follows:
WEEKDAY/A10 = DECODE DAY_OF_WEEK('1' 'Sunday'
'2' 'Monday'
'3' 'Tuesday'
'4' 'Wednesday'
'5' 'Thursday'
'6' 'Friday'
'7' 'Saturday'ELSE ' ');
I'm not sure if I'm coding it correctly, also where I'm supposed to place it in the code.

Any input would help.

This message has been edited. Last edited by: DMA,

You're getting your result in alphabetical order because your program probably does:

BY WEEKDAY

it should do:

BY DAY_OF_WEEK NOPRINT
BY WEEKDAY