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.