Progress 9.1D SQL If Statement

[bugg_tb]

May be a dumb question..
If(PUB.D2_SORD_DEL_HEAD.sdh_del_method='001','D','C') AS ORDERTYPE
if that sorta thing right for an IF statement or have I got it wrong? Cause no matter what I try I get a syntax error.

Cheers

Tom

 

[bugg_tb]

Never mind, I found out it likes CASE statements