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!