title: "contains" in Bigquery standard SQL
body: <p>I wish to migrate from Legacy SQL to Standard SQL</p>
  
  <p>I had the following code in Legacy SQL</p>
  
  <pre><code>SELECT
    hits.page.pageTitle
  FROM [mytable] 
  WHERE hits.page.pageTitle contains '%' 
  </code></pre>
  
  <p>And I tried this in Standard SQL:</p>
  
  <pre><code>SELECT
    hits.page.pageTitle
  FROM `mytable` 
  WHERE STRPOS(hits.page.pageTitle, "%") 
  </code></pre>
  
  <p>But it gives me this error: </p>
  
  <blockquote>
    <p>Error: Cannot access field page on a value with type
    ARRAY> at [4:21]</p>
  </blockquote>