Logic Issue (IF)

[tmumaw]

Does anyone see anything wrong with this logic?  Thanks......

if(mid(MntPlan_WARPL,1,3) = 'PMA', mid(MntPlan_WARPL,1,3),
      if(mid(MntPlan_WARPL,1,5) = 'PMA/D', mid(MntPlan_WARPL,1,5))) as PM_Type,

[Clever_Anjos · Accepted solution]

mid(MntPlan_WARPL,1,5) = 'PMA/D' would never be satisfied since mid(MntPlan_WARPL,1,3) = 'PMA' is satisfied first

[antoniotiman]

This is correct sintax.

Ovewer if You have 'PMA/D' You also have 'PMA'

So, else condition never works.

I suggest to revers conditions.

Regards,

Antonio

[tmumaw]

Thanks.....too early in the morning and only one cup of coffee......

[Clever_Anjos]

I´ve already have 3 cups