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

Posted to dev@calcite.apache.org by Jess Balint <jb...@gmail.com> on 2019/06/06 17:01:17 UTC

is there CHARINDEX function?

Is there a function which searches for a substring? Thanks.

Jess

Re: is there CHARINDEX function?

Posted by Yuzhao Chen <yu...@gmail.com>.

The SUBSTRING function in SqlStdOperatorTable may be what you needs.

[1] https://github.com/apache/calcite/blob/614b4350f558a4fabaafc06fef9689ec4c267994/core/src/main/java/org/apache/calcite/sql/fun/SqlStdOperatorTable.java#L1428

Best,
Danny Chan
在 2019年6月7日 +0800 AM1:01，Jess Balint <jb...@gmail.com>，写道：
> Is there a function which searches for a substring? Thanks.
>
> Jess