Conversion of IF

[#1]

Hi All,

Can anyone help me with the conversion of below if loop to case statement. I want to use the below logic in the select statement.

if(MATCH_TYPE = 'VOD','Tier 1',

  if(MATCH_TYPE <> 'VOD' AND Match(NETWORK_TYPE,'Broadcast', 'Cable') AND Len(Trim(PROGRAM_NAME)) <> 0,

      if((TIMESHIFT_INDICATOR_ID >= 10 AND TIMESHIFT_INDICATOR_ID <= 16) And SAMPLE <> 0,

            'Tier 2','Tier 1')))

As Field_Name

[ogster1974]

These techniques will help.

Re: Multiple IF, PICK AND MATCH

[settu_periasamy]

Looks like the same thread here

RE:Change if

[reddy-s]

Hi Ravikiran,

Check this out:

purpose of pick and match.