title: How to remove all characters after a certain character in BigQuery using standard SQL?
body: <p>I have a list of URLs/ Here is an example — <a href="http://www.site.com/product/item1/?utm_source=google&amp;utm_medium=cpc" rel="nofollow noreferrer">www.site.com/product/item1/?utm_source=google&amp;utm_medium=cpc</a></p>
  <p>How I can get all characters before question mark using BigQuery? Sо I want to get <a href="http://www.site.com/product/item1/" rel="nofollow noreferrer">www.site.com/product/item1/</a> from this string.</p>
  <p>Thanks a lot!</p>