1 Reply Latest reply on Jul 29, 2015 8:55 AM by Saubhik

    Pattern string search in sql

    858328

      Hi All,

       

      Could you please help me on the below post.

       

      I have country table "TEST_CTRY_TBL" and it has one column as ctry_name.


      CTRY_NAME

      LONDON

       

      I am passing the input string from front end and it just like below.

      INPUT string:   AAB|O6578111|TRAVEL_LONDON|UK

       

      How to search word of 'LONDON' which is from input string with ctry_name column from table.

       

       

      Thanks