modifying a string variable
<p>I have a string variable which is named <code>query</code>.  It's value is:</p>

<blockquote>
  <p>select col1, col2 from tab1<br>
  inner join (select col3, col4 from tab2)</p>
</blockquote>

<p>Would it be possible to apply a treatment to this string variable to replace the first appearance of <code>select</code> with <code>select top 100</code>?</p>

<p>The string variable should become:</p>

<blockquote>
  <p>select top 100 col1, col2 from tab1<br>
  inner join (select col3, col4 from tab2)</p>
</blockquote>
