sql server - Replace comma separated numbers with weekdays in SQL -

i saving weekends in table 0,6 (for sunday,saturday) , weekdays 1,4,6(for monday,thursday,saturday). while selecting need replace numbers appropriate weekdays. example.,

select weekend_days table_1 

returns

weekend_days 1,4,6 

but need o/p as

weekend_days  monday,thursday,saturday 

how achieve this? in advance...

use ugly replace() can job

select     weekend_days,      replace(     replace(     replace(     replace(     replace(     replace(     replace(weekend_days      , 1, 'monday')      , 2, 'tuesday')      , 3, 'wensday')      , 4, 'thursday')      , 5, 'friday')      , 6, 'saturday')      , 0, 'sunday') weekend_days_name (values('1,4,6')) table_1(weekend_days)