Flexible LIKE operator

Question

I'm new to SubSonic. I've been looking for a way to use LIKE operator that let me build SQL query like this: select * from person where lastname like '%bob%', but I could not find a generic way to do this beside inserting string into the quey like q.OR(Person.Columns.FirstName, SubSonic.Comparison.Like, "%bob%");

that is not a prefered way since different DB may user different operator other than %

Answer 1

Can I use SimpleRepository to perform like comparison?