Not in Container Managed Persistence, there isn't. In Bean Managed Persistence, of course you can write any SQL you like in your ejbFind... methods.
Kyle
------------------
Kyle Brown,
Author of
Enterprise Java (tm) Programming with IBM Websphere
See my homepage at
http://members.aol.com/kgb1001001 for other WebSphere information.