I always wondered what would be the exact returned values in various scenarios when I use the Oracle / PLSql instr function.Now I can read it here:http://www.techonthenet.com/oracle/functions/instr.php