You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Tanner Clary (Jira)" <ji...@apache.org> on 2023/03/14 17:17:00 UTC

[jira] [Created] (CALCITE-5585) Add STRPOS() Function (Enabled for BigQuery)

Tanner Clary created CALCITE-5585:
-------------------------------------

             Summary: Add STRPOS() Function (Enabled for BigQuery)
                 Key: CALCITE-5585
                 URL: https://issues.apache.org/jira/browse/CALCITE-5585
             Project: Calcite
          Issue Type: Improvement
            Reporter: Tanner Clary
            Assignee: Tanner Clary


BigQuery supports the {{STRPOS()}} function with accepts 2 {{STRINGS}} as arguments. The function returns the 1-based position of the first occurrence of the second string within the first (example below). If no occurrence is found, the function returns 0. The function also supports ByteStrings with the same behavior.

EXAMPLE: {{STRPOS("abc", "bc")}} would return: {{2}}.
EXAMPLE: {{STRPOS("abc", "d")}} would return: {{0}}.

[BigQuery docs](https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#strpos)



--
This message was sent by Atlassian Jira
(v8.20.10#820010)