I would like to (I have to) use SUBSTRING in a JPA-Query. But it's obviously not translated into the correct Firebird syntax using SUBSTRING(value FROM start FOR length).
Is there anything special I need to do for that? Some configuration?

--Heiko