HI
I have a small query. The name column which is varchar returns 01,02,03 etc.... I want to replace if 01 to say Jan, If 02 to say Feb etc....
How can achieve this please. Any ideas, many thanks in advance
I have a small query. The name column which is varchar returns 01,02,03 etc.... I want to replace if 01 to say Jan, If 02 to say Feb etc....
How can achieve this please. Any ideas, many thanks in advance
SQL:
SELECT asset, name AS Month, MoulderEvents, ModTime, PLEvents, PLTime, OverrunEvents, OVRTime
FROM [PLANTRUN-ABF\SQLEXPRESS].prodigy_data_quickstats_2023.dbo.reasoncodes2023cp AS reasoncodes2023cp_1