Comaprint in Informatica, using the LIKE Keyword

[srjosyula]

Hi
I need to compare a field in my expression trasformation
say in SQL i can use: like '%week'
Can I use something like this in informatica?
in the expr transformation:
IIF(format like '%week', weekly, monthly)
please help
need urgently
thanks in advance

 

[srjosyula]

There was a typo sorry it is supposd to be COMAPRISION IN EXPRESSION.....

 

[blom0344]

You mean comparison?

Try this:

IIF(RTRIM(SUBSTR(format,-4,4)),'week',' weekly','monthly')

Ties Blom

 

[srjosyula]

Thank you very much for the timely help...Will try and let you know

 

[srjosyula]

It works like a charm, thank you very much