By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
cols |
---|
(case when ',' + column1 + ',' like '%,a,%' then 'x' end) as a (case when ',' + column1 + ',' like '%,b,%' then 'x' end) as b (case when ',' + column1 + ',' like '%,c,%' then 'x' end) as c (case when ',' + column1 + ',' like '%,d,%' then 'x' end) as d (case when ',' + column1 + ',' like '%,e,%' then 'x' end) as e (case when ',' + column1 + ',' like '%,f,%' then 'x' end) as f |