2 Replies Latest reply on Jan 16, 2013 9:22 AM by shawkins

    Proper use of the CHARINDEX function


      Running the query


      SELECT CHARINDEX('1', '12345')

      FROM MyDatabase




      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?