Hi
sum(case (t0.comments) when 'Milk' then t1.Quantity else 0 end) Milk
How to use like with when
sum(case (t0.comments) when like '%Mil%' then t1.Quantity else 0 end) Milk
Thanks