the above Query works with short names of the month

Declare @month as varchar(10)

set @Month = 'Dec'

select Month(@month + ' 1 2010')