By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
declare @a table( c varchar(100))
insert into @a
(c) values
('2,4,5');
declare @equivalenttable table( id varchar(100),equivalent varchar(100) )
insert into @equivalenttable
(id,equivalent) values
('2' ,'active'),
('4' ,'closd'),
('5' ,'inactv');
select string_agg(equivalent,',') within group (order by id) c from (
select a1.value from @a
CROSS APPLY STRING_SPLIT(c, ',') a1) a2
join @equivalenttable e
on a2.value=e.id
| c |
|---|
| active,closd,inactv |