input parameters CANNOT be used in LIKE expression.
Originally posted by Ugender Rekulampally: Lynette Dawson, No, We can use LIKE expression. And the example you have given is correct. you can look page 419 of HFEJB for some examples.
you can try: SELECT a FROM Address AS a WHERE a.address_1 like '?1'