sql server - Select month in MMM format -

How do I select the month where the month field is in MMM format, such as in January, February, March in the IMONTH field The months listed are I used the Detector function but the destination field type is in nvarchar format and I get an error below: Error converting nvarchar value to 'mars' to data type difference conversion failed.

When I use the Datanum function, the query runs, but no output is drawn, I am starting SQL programming and any help will be useful.

option

1. your iMonth one Type actual date
2. Create a lookup table for 3-digit months and join your query.