How to use case statement this Query

Question

How to use case statement this Query.

(select SUM(VPRC_60.receipt_rf_amt) as Before from VPRC_60, VPRC_13 where VPRC_13.proj_adopt>= VPRC_60.dt_for and VPRC_60.receipt_rf_amt <> 0 and VPRC_60.Rpt_unit = VPRC_13.Rpt_unit)

Thanks&Regs

Manavalan

Jignesh Trivedi · Answer

Hi try for Select.. select case d.condition when 1 then 'Test' else 'test1' end  * from TableName In where ... select * from tablename d where (case d.condition when 1 then 'Test' else 'test1' end) = 'test1' hope this help.

Vulpes · Answer

I don't see how you can use a CASE expression here as there are no alternatives. In your WHERE clause there are just three simple conditions AND'ed together.