How to Use "Like"

Hi,

I want to filter records that records starts with the letter a, b .......  or z depend on the user choice should show.

but the problem is that i dont know that ho can i use "Like" operator in subsonic as we used in sqlserver.

can anyone help me that how can i use it in subsonic.

thx

Subsonic.Select s = New SubsonicSelect();
s.From(MyTable);
s.Where("Column").Like(whatmyuserwants + "%");
MyTableCollection c = s.ExecuteAsCollection<MyTableCollection>;

Lots of syntax help at http://subsonicproject.com/2-1-pakala/subsonic-version-2-1-pakala-preview-the-new-query-tool/

Heloo,

Thx for reply but i could not find subsonc.select and i m using vb can you please  define it in vb thx.

Dim s as New Subsonic.[Select]()
s.From(MyTable)
s.Where("Column").Like(whatmyuserwants & "%")
Dim c as MyTableCollection = s.ExecuteAsCollection(of MyTableCollection)()

Heloo dear,

thx for reply.. when i use it like this it shows error that

"subsonic.select type is not defined" any other idea plz thx

 I would recommend upgrading to Subsonic 2.1, it sounds like you are on 2.03.

Hi Dear,

Thanks i find the soloution in 2.1 now i need to know one thing that from where i can download subsonic CMS.

atifarif:

Hi Dear,

Thanks i find the soloution in 2.1 now i need to know one thing that from where i can download subsonic CMS.

Really? You've been asking this question for five days now? It's honestly not that hard to figure out. Now, I'm sorry that I didn't answer this question on this thread when I read it the first time, but after a while, it gets kind of old. If you can't find a download link for the subsonic cms without someone typing it out for you, you're in the wrong business. It's been downloaded 20,000+ thousand times in the last year. Thank goodness most people were capable of finding it on their own.