Subsonic 3 query like clause

subsonicsubsonic3

This may be another of those "should be simple" things, but I can't find anything on it so here I am asking what will most likely be a stupid question :$

I'm using SubSonic 3 and I want to execute a query with a like clause but can't find that as an option. My straight SQL is like so:

select * from table where column like %value% or column like %anothervalue%

Thanks for any help.

Jon

Best Answer

If you're using Linq you can use StartsWith(), EndsWith(), and Contains()