I wanted to extract all the characters that lie on the right side of the matching character using BigQuery.
eg:
Suppose I wanted to extract all characters right of '-'
then:

1. happy-holiday will give holiday
2. gogoa-gone will give gone

Can someone help me with this