title: How to extract an ID number from a URL string in SQL?
body: <p>I am trying to extract an ID from a URL and running into some issues.  The URL's will look something like this:</p>
  <blockquote>
  <p><a href="http://www.website.com/news/view.aspx?id=95" rel="nofollow noreferrer">http://www.website.com/news/view.aspx?id=95</a></p>
  <p><a href="http://www.website.com/news/view.aspx?id=20&amp;ReturnURL=%2fnews%2fview.aspx%3fid%3d20" rel="nofollow noreferrer">http://www.website.com/news/view.aspx?id=20&amp;ReturnURL=%2fnews%2fview.aspx%3fid%3d20</a></p>
  </blockquote>
  <p>I am trying to return back the number following &quot;?id=&quot; and nothing after the number.  I will then convert it to an INT in reference to another table.  Any suggestions as how to do this properly?</p>