How do I write the below statement without using
When (IsNull(Email_Ind, '') != 'N'
When Email_Ind != 'N' and Email_Ind is not null
Your case statement looks fine. It's just a matter of preference on how to write it. To me, this is more easily understandable but that's not the case for all i'm sure.
Case When Email_Ind != 'N' or Email_Ind is null then 'e' else 'n' end