@Ross_Metusalem is right, you can use a regular expression but, if you're like me and have never gotten the hang of them, you'll probably find that the character functions in JMP can give you most of the flexibility you need.
In this case, Contains() and Substr() work really well. If you want a case insensitive comparison you can use Lowercase() to get rid of the casing.
Contains() and Substr()
Lowercase()
Note that the -1 argument in Substr() means "to the end of the string".
@Craige_Hales has some good hints on the character string functions: JSL Character String Functions
-Jeff