Like Operator

To control whether a value matches a pattern with wildcards, use the % wildcard. Use the wildcard at the beginning or at the end of the pattern; never use it inside the pattern.

Material Like 'Crude%'

Any material starting with Crude.

Material like '%ude'

Any material ending with the string ude.

Material like '%rud%'

Any material containing the string rud.

If the pattern contains * % [ ] they should be escaped enclosing them within brackets like [*]

Material like '%r[*]ud%'

Any material containing r*ud.