case in where clause of select-statement

[gregor.artmann]

is it possible to use a case in the where-clause of a statement ?

[nathan.e.schroeder]

Sure - something like

WHERE a.acct_id = (CASE WHEN b.type=‘C’ then b.acct_id_1 else b.acct_id_2 END)