Derby does now in fact support the full ANSI SQL TRIM function -------------------------------------------------------------- Key: HHH-4705 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4705 Project: Hibernate Core Issue Type: Improvement Components: core, query-criteria, query-hql Reporter: Steve Ebersole Assignee: Steve Ebersole Fix For: 3.5 According to http://issues.apache.org/jira/browse/DERBY-1623 it has since 10.3.1.4 which was released 10/Aug/07. So probably safe to go ahead and enable support for it -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira