Case When statement
Is it possible to use contains instead of = in the Case When statement
CASE when 'Amount'=1 then 10 else 0 End
For example: Case when 'Reason' contains 'Retal' then 'Retaliation' Else 'Other' End
we have many different variations of Retaliation statements and don't want to spell each one out in a case when statement
Fear of Retaliation, I feel retaliated, Fear retaliated against, etc.
want to combine all the variations into one bucket of Retaliation.
Thank you, Jill Bowers