2 Replies Latest reply on Oct 3, 2013 10:52 AM by Steven Hawkins

    LOCATE and CLOBs

    Diogo Patrao Newbie

      Hello all

       

      I'm using Teiid 7.8, and I need to locate a certain substring within a CLOB column. Locate won't work, and if I convert the column to string it will work only if the substring is 4,000 chars or smaller.

       

      How can I LOCATE stuff within CLOBS?

       

      Thanks a lot!

       

      dfcp