5 Replies Latest reply: May 22, 2014 10:10 AM by Lyn Lyn RSS

    Searching for a specific string

      Hi All,

       

      I have a question regarding searching for a specific string.

       

      Lets say I have data:

       

      table1:

      KEYCODE
      ABCAB
      DEFDE
      XYZXY

       

      table2:

      KEYFIELD1
      ABCG-H-G-H-G-A-B-AB-ABC
      DEFAB-AB-DE-EF
      XYZABC-XY-QYZ

       

      In Key ABC, I have to find the CODE (AB) in FIELD1 (G-H-G-H-G-A-B-AB-ABC).

       

      How do I do this?

       

      Thanks,

      Lyn