hi all,

I am converting my application from EJB2.1(EntityBean) to HIbernate 3.1. I am planning to use the same ejb-ql which is passed from front-end with hibernate as hql. All most all query are working fine except locate() method.

when I was using locate() with entityBean for example

Select object(c) from CoolerInfoValue c where locate((c.contactPerson),'yan')>=1

it selects all contactperson which start with 'yan'. i.e. yan hang, yang hann etc


but when i use the same query above with hibernate createQuery(),

it selects only the contactperson yan ie it is searching the entire word no wild card search as in EntityBean.

I am using MS-SQL Server as my db.

can any one help me out,

Thanks,
Joseph.C