Proper use of the CHARINDEX function

[mcasperson]

Running the query

SELECT CHARINDEX('1', '12345')

FROM MyDatabase

returns

09:03:07  [SELECT - 0 row(s), 0.000 secs]  [Error Code: 0, SQL State: ERR.015.008.0039]  Error Code:ERR.015.008.0039 Message:Remote org.teiid.api.exception.query.QueryResolverException: Error Code:ERR.015.008.0039 Message:The function 'CHARINDEX('1', '12345')' is an unknown form.  Check that the function name and number of arguments is correct.

What is the correct usage of CHARINDEX with TEIID?

[mcasperson]

Never mind. LOCATE() works instead.

[shawkins]

If you want, log an issue and we can create a function alias for CHARINDEX to LOCATE.

Steve