Case when then sql statement else condition returns null value

See more:

SQL-Server-2008

T-SQL

Hi experts,

Here is my sql querry

declare @lastPensionMonth varchar(50)
Select top 1 @lastPensionMonth = case  when BMT_MONTH= '1' then 'jan'
                                       when BMT_MONTH= '2' then 'feb'
                                       when BMT_MONTH= '3' then 'mar'
                                       when BMT_MONTH= '4' then 'apr'
                                       when BMT_MONTH= '5' then 'may'
                                       when BMT_MONTH= '6' then 'jun'
                                       when BMT_MONTH= '7' then 'jul'
                                       when BMT_MONTH= '8' then 'aug'
                                       when BMT_MONTH= '9' then 'spt'
                                       when BMT_MONTH= '10' then 'oct'
                                       when BMT_MONTH= '11' then 'nov'
                                       when BMT_MONTH= '12' then 'dec'
                                                else
                                       'Not started to take pension'
                                                end
                                                from Beneficiary_Monthly_Pension_Tran where BMT_Beneficiary_ID='000002316'
                                                order by bmt_year desc
                                                select @lastPensionMonth

It is not returning the else condition string for the true part it is working properly
false part it is returning null value. Can Any one please tell me the mistake.

Thanks in advance
(Keerthi Kumar)