SELECT CASE and SELECT IF

jddsc

New Member
Hi guys

I'm fairly new to Progress SQL programming... I'm using Business Objects to extract some data from OpenEdge v10. What I'd like to do, is use a SELECT CASE or SELECT IF statement, to return results based on a condition.

Something like
SELECT <field>
CASE WHEN <field> = 'A' THEN 1
CASE WHEN <field> = 'B' THEN 2
CASE WHEN <field> = 'C' THEN 3
END CASE

Can someone point me in the right direction with an example? Nothing I try seems to work successfully in my select statements.

Thanks all
James
 
Back
Top