Is it possible to create a user filter for a report that includes all items in a column that contains a text value?

For example, create user filter on Customer Name where Customer Name contains the value 'smith'.

The equivalent SQL statement would be:

Select

*

From Customer

Where

[Customer Name] Like '%smith%'

Of course I do not want to create a query table for this. The report is for a business user who may want to change the user filter dynamically when running a report.

Cheers

Sunil