I'm trying to find multiple numbers (61 and 62) using instr. Please see below;
select instr('262,500,61', '61') sixty_one, instr('262,500,61', '62') sixty_two
from dual;
The problem is that the sixty_two field is returning a value, whereas, it should be returning 0. What approach can I apply to make sixty_two field return 0 because there is the number 62 doesn't exist?
Thanks in advance