I need to do a table level constraint that does...

in the acct table...if acct_type is "1" then acct_bal must be > 0, if acc_type is "2" then acct_bal must be > 100, etc..

All the fields are within the same table.

Thanks,
Erik