How find exact string match within a string
258957May 13 2009 — edited Jul 7 2009Hi ALL,
There is a requirement from a client to display records which contain some specific characters within an existing column. The data to be check is stored as a varchar2 and the values inside the column can be delimited by any or no specific character.
1. The user will enter to values which indicate a start and end value.
2. Each row needs to be checked if it contains any or all of the values between the start and end values given by the User.
e.g. The table contains a column called HOUSE_BLK_NO , now this would normally be a single value but in the current client site the values are multiple i.e.
one row can have the value as ' 1234, 234A, 56 345' in the above mentioned column
3. The user will input the value 34 to 80
If I do a simple instr it will return me the above row even for 34 which is incorrect.
Can someone help in this regard. I know the possiblity of using context search but not sure if the Client has installed the same and also I do not have the proper knowledge of Context Search.
Appreciate if any one can help.
Thanks
Regards