By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE dbo.BadIdeas
(
[Month Year Raw] nvarchar(6),
[Month Year] nvarchar(32)
);
INSERT dbo.BadIdeas([Month Year Raw]) VALUES(N'202201'),(N'202009');
2 rows affected
UPDATE dbo.BadIdeas
SET [Month Year] = CONCAT
(
DATENAME(MONTH, CONVERT(datetime,
[Month Year Raw] + '01', 112)),
' ',
YEAR(CONVERT(datetime,
[Month Year Raw] + '01', 112))
);
2 rows affected
SELECT * FROM dbo.BadIdeas;
| Month Year Raw | Month Year |
|---|---|
| 202201 | January 2022 |
| 202009 | September 2020 |