user09644 Member

  • Re: Case When statement

    @user082291 You'll want to use wildcard character to achieve this. I like to wrap the upper() function to remove casing variability. CASE WHEN UPPER('REASON') LIKE ('RETAL%') then 'Retaliation' ELSE …