IF statement to match string within field

[wesbrowning]

I've been trying many ideas but no luck and hoping the community can assist. 

I am wanting to "look" within a field and when I match a particular string of characters, in this case "IBM", return a "Yes" text string into my table.  Something like:

=IF[(Field) Contains string(IBM), Return "Yes"]

I know that's not proper syntax but hoping writing out the logic conveys my goals better.

Any help greatly appreciated!  Thanks... Wes

[sunny_talwar]

Try this

If(WildMatch(Field, '*IBM*'), 'Yes')

[sunny_talwar · Accepted solution]

You can also try this

If(Field LIKE '*IBM*', 'Yes')

[wesbrowning]

Thanks Sunny!  This is perfect...

[crichter14]

Sunny - what if you wanted to return just the substring that had the 'IBM' in it?  What would you change the 'YES' too.

If(Field LIKE '*IBM*', 'Yes')

[Almen]

Should be 

If([Field] LIKE '*IBM*', [Field])