If [variable] contains (string)

all-tricks-rick

Is there a function that exists that does the following: If a variable contains a certain string of characters, then it is to be included in the IF function and will produce the positive of my conditional statement.

For example, my formula is as follows:

IIF([Financial Type]="Swap" and [Instrument Desc] IN("Baseload") and [Underlying Instrument Desc] = "French","Power Swap - French Baseload","No")

I am currently using an "IN" function but that only returns exactly "Baseload". I want it to include all phrases that include the word "Baseload". Any help on this?

Thanks!

BenMoss

Contains([field],'string')

This sounds what you are looking for.

Ben