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
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