Anjali,

You dont have to have same thing for the dates. You can go with the approach suggested above:

select datename(mm,getdate()) --retuns a value of January

and then if you just want the 1st 3 letters add a left to the command

select left(datename(mm,getdate()),3) --retuns a value of Jan

You just have to break your date field into months...:-)

Rookie