Error in jasper using CASE

[shakarim]

Hi All

I had use the CASE condtion in sql statmet , its work fine in Sql server , giving error in jasper report

select  CONVERT (DATE,delivered_dt), SUM( CASE UPPER(_ITEM_DESCRIPTION)  WHEN  'EAR RING'  THEN  2  ELSE  1  END)  jobcount, sum(quantity)

Thanks in advance