How to convert IF statement into CASE statement?

Question

I want to convert the following IF statement into CASE statement, since it doesn't work in Alteryx, which is using a Snowflake database.

IF LEFT([SN],3)="CAT" AND Length([SN])=17 THEN RIGHT([SN],8) ELSE [SN] ENDIF

Could you please help me?

score 2 · Answer 1 · answered Jun 08 '22 at 18:28

2

Using CASE expression:

SELECT CASE WHEN SN LIKE 'CAT%' AND LENGTH(SN) = 17 THEN RIGHT(SN,8) 
            ELSE SN
       END

or IFF:

SELECT IFF(SN LIKE 'CAT%' AND LENGTH(SN) = 17, RIGHT(SN,8), SN)

answered Jun 08 '22 at 18:28

Lukasz Szozda

1

IFF SELECT IFF(SN LIKE 'CAT%' AND LENGTH(SN) = 17, RIGHT(SN,8), SN) Worked perfectly thank you! – Evoz Jun 08 '22 at 18:33
@Evoz Great to hear it https://stackoverflow.com/help/accepted-answer – Lukasz Szozda Jun 08 '22 at 18:35

1 Answers1