Hello Parity Bit:
The Art Shop has a example (where you search for products) that demonstrates the use of a SQL LIKE.
You'll find it in the Products action method in the ProductController.
I think where you got confused is the placement of the '%'.
It should be placed on the value, rather than the parameter, something like this:
Hope this helps.
Jack Poorte, Sep 12, 2013