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)
