Using INSTR in BigQuery

If you ever need to do something different based on the existence of a particular substring in hashtag#BigQuery, take a look at the INSTR function. It returns the 1-based index of the first occurrence of a substring (1 or more characters) in another ...