add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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