Filter to find string anywhere?

​I want to filter down data if it contains a certain word. For example if I have a bunch of names in a column.

Smith, John Rae
Johnson, Greg Allen
Mitchell, Tim Jean

I want to filter and see anything that contains "Greg"

How would I do that?

I have tried using things like

[Name]="*GREG*" no luck...

Any Help is appreciated.

------------------------------
Vaughn Mitchell
Data Analyst
Avera Health
NA
555-5555
------------------------------