Wild Card Syntax in If Statement

What is the syntax for a wildcard in an if statement?

For example, if I have a text field that contains multiple names, and I want to have a condition if the field contains the name Mike,

The following returns a field with the name mike, but what if I dont care about exact match, just want it to contain that word?
If([Text Field] = "Mike", condition, condition)

I was hoping for something like
If([Text Field] = *"Mike"*, condition,condition)

That didn't work though. Can't find the correct syntax?

Thanks