Skip to Content
0
Former Member
Jan 17, 2011 at 01:35 PM

Query

20 Views

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