IF statements

[astarbyfar]

Im using a RunSQL Macro and just wondering if this version of SQL supports the IF statement used in the likes of C programming

I want to use the UPDATE statement with it, so if i can use it and someone suggest the layout Thanks in advance astarbyfar