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

    Proper use of the CHARINDEX function

    Matthew Casperson Newbie

      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?