Paulo Pinto

I'm using now JBoss 4.2.3.GA and that SUBSTRING doesn't seem to work for this purpose anymore.

But I tried this and it worked for me:
SELECT OBJECT(o) FROM Person o WHERE o.name LIKE CONCAT('%', ?1)

This simulates the query:
SELECT OBJECT(o) FROM Person o WHERE o.name LIKE %?1

You can even do a CONCAT(CONCAT('%', ?1), '%') if you need something like '%?1%' instead.