title: charindex function at big query
body: <p>I have below sql query and need to run at bigquery</p>
  <pre><code>select replace(substring(p.name, charindex(',', p.name), len(p.name)), ',', '') AS [First_Name] from people p
  </code></pre>
  <p>so I have tried below big query syntax</p>
  <pre><code>select replace(SUBSTR(p.name, charindex(',', p.name), len(p.name)), ',', '') AS [First_Name] from people
  </code></pre>
  <p>but i am getting below error</p>
  <pre><code>Function not found: charindex at [1:1]
  </code></pre>