7 Replies Latest reply on Oct 30, 2017 9:22 AM by Steven Hawkins

    Proper use of the CHARINDEX function

    Aditi Patel Newbie

      What is the proper usage of CharIndex function in Teiid. I am trying to execute below query with charindex function and it is throwing error.

       

      charindex('MeContext',DC.DIM_E_LTE_EUCELL_CELL.hostingDigitalUnit)

       

      {Above is only part of the charIndex in the select query}

       

      Output:

       

      17:06:09  [SELECT - 0 row(s), 0.000 secs]  [Error Code: 30068, SQL State: 50000]  TEIID30068 Remote org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'charindex('MeContext', DC.DIM_E_LTE_EUCELL_CELL.hostingDigitalUnit)' is an unknown form.  Check that the function name and number of arguments is correct.