How to implement " like" condition

[deesh]

Hi friends,

Can any one help me how to solve below like condition logic in datastage

if okmodl+ okexcd+oktedl contains 'FOB' then 'Y00' else 'y01'--> For this we need "FOB" word either its FOB or ENFOB or LLELFOBND, Just among this FOB word we need

[chulett]

The Index() function is used to locate a substring within a string, you can use the return value from it as a boolean if all you want is true/false, it found it or it didn't.