title: How to strip Querystring from a field in T-SQL?
body: <p>I have a SQL table full of logs that shows response time from my pages. For example:</p>
  
  <pre><code>/MyPage1.aspx
  /MyPage2.aspx
  /MyPage3.aspx?index=4
  /MyPage3.aspx?index=5
  /MyPage3.aspx?index=7
  </code></pre>
  
  <p>However, I want to create a view that shows me the average load time for each page. To do this, I don't want the query strings included since I just want to group the pages by their URL before the question mark (so <code>/MyPage3.aspx</code> only shows up once).</p>
  
  <p>What string functions are appropriate here to strip out the query string?</p>