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 · Accepted solution]

Contains([field],'string')

This sounds what you are looking for.

Ben

[all-tricks-rick]

Thanks! Is there a reverse of this function? i.e. not contains ? or something like that

[bslipetz3]

Put a ! in front of the Contains     !Contains for indicating does not contain