Hibernate version:3

how to VARCHAR2 to NUMBER in HQL query . EXP :

select SUM(toto.nbC) from TAB as toto where toto.name=:myname";

nbC isdeclared VARCHAR2 instead of NUMBER so i tried this cast:

select SUM(cast(toto.nbC as INTEGER)) from TAB as toto where toto.name=:myname";

but i found a probleme with : cast (toto.nbC as ???)

I also tried to reimplement the getter of nbC but i have error.

Any idea please.

thanks.