INSTR('Tech on the net', 'e') | would return 2; the first occurrence of 'e' |
INSTR('Tech on the net', 'e', 1, 1) | would return 2; the first occurrence of 'e' |
INSTR('Tech on the net', 'e', 1, 2) | would return 11; the second occurrence of 'e' |
INSTR('Tech on the net', 'e', 1, 3) | would return 14; the third occurrence of 'e' |
INSTR('Tech on the net', 'e', -3, 2) | would return 2 |
Whatever topic has been discussed on this blog is my own finding and views, not necessary match with others. I strongly recommend you to do a test before you implement the piece of advice given at my blog.
Tuesday, February 4, 2014
INSTR FUNCTION
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment