HQL regex

xanlex · **Joined:** Wed Aug 29, 2007 11:23 pm **Posts:** 1

i'm using hibernate 3.2
i need to use regex in my hql
can some one help me
cause i already search in refence and can't find it

my query is
FROM com.data.Master WHERE employee_id like '[a-zA-Z]'
i want to search just the employee_id which not contain numeric

i try in sql server, it's work, but in hql it doesn't work

thx

ge0ffrey · **Joined:** Thu Oct 13, 2005 4:19 am **Posts:** 98

use rlike
http://opensource.atlassian.com/projects/hibernate/browse/HB-1034

tkrah · **Joined:** Mon Dec 01, 2008 1:40 pm **Posts:** 5

http://opensource.atlassian.com/project ... e/HHH-3404