Getting parts of a string into a collection
<p>I have a sql string as follows:</p>

<pre><code>select a, b, c from test where a = s and b = 3
</code></pre>

<p>Using C# 2.0 specifically, how can I get:</p>

<p>a = s, b = 3</p>

<p>But in the form of a collection, so one member is "a = s", the other is "b = 3"?</p>

<p>Thanks
P.S. Table names have been changed but the point remains</p>

<p>EDIT: I have just realised I could get a substring from where onwards and then split it where there are commas and an and. Is there a better way?</p>
