Hello ,
you have to use
SUBSTRING
in your query to get first 3 letters of the month.
modify the query
SELECT SUBSTRING(DATENAME(MONTH, CAST(CAST(YEAR(GETDATE()) AS VARCHAR)
+ '-' + CAST('2' AS VARCHAR) + '-01' AS DATETIME)),1,3) AS MonthName
For more details on substring go through
This link
thanks