I need to do the following SQL in HQL:

select * from item i
where BIGINT(i.acct) NOT IN (select accountnumber
from DACS_INDICATOR_TABLE)

acct = VARCHAR
accountnumber = BIGINT

HQL =

from ItemVO as item where item.acct not in
(select dacs.acctNumber from DACSIndicatorTableVO as dacs)


but this gives an error

“SEVERE: The data types of the operands for the operation "IN" are not compatible.”

Is there a way to convert the VARCHAR to a BIGINT in HQL?

I found the cast(… as …) function but I have not been able to get it to work.