Conditional logic in alert messages

csweet

I'd like to apply some conditional logic to my messages.  For example, if a variable has value A then print out certain variables, otherwise print out a different set of variables. 

I'm basically asking if an IF statement can be used in the email message alert

nelsonc0

you could do a custom sql variable, and use the where clause would be a bit tricky but I think it would be doable.