When I use in WHERE clause SUBSTR(:InputParameter, 1, 5) it works only if there is only one match in the db. If there are more than one matches it fails to execute. Is there another way to use a combination of SUBSTR and :InputParameter in plain SQL so as to avoid using PL/SQL?