Toad World® Forums

case in where clause of select-statement

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

Sure - something like

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