Sort By Date in a logic order ???

[newyork66]

I have a database column is month (months as 3-char abbrevs, the data looks like ' NOV' ,'JAN', 'OCT' ....) in Cognos report studio how can I sort by those months so it can be displayed by a logical order like Jan, Feb, March, Apr...ect order it logically?

[phanicrn]

write a case statement

case month= jan then 1
month=feb then 2
else ('')
end

sort by this column, or do advance sorting, it will work..