Could you please help me on the below post.
I have country table "TEST_CTRY_TBL" and it has one column as ctry_name.
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.
What about INSTR ?