I'm having a problem getting regexp to work in a HQL - can someone help me with this? Also note the spring framework hibernate3 patch
----------

ver: Hibernate3

stack -->
org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: regexp near line 1, column 78
[from com.xxx.bean.Product product where lower(product.displayName) regexp '[0-9]']; nested exception is org.hibernate.hql.ast.QuerySyntaxError:
unexpected token: regexp near line 1, column 78 [from com.xxx.bean.Product product where lower(product.displayName) regexp '[0-9]']
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:558)

HQL
----
Product product where lower(product.displayName) regexp '[0-9]']

Well, you basically can't use vendor-specific functions in HQL if they are not in a "function form" like function(arg1,...,argN)

I thought WhereParser.java had this attrib (regexp) added to it. If this is the case should not it wotk just as "like" or such would?

Thx
A