I need to cast a string value to an integer value to do basically this...

select max(cast(myStringColumn as Int32)) where ...


But this seem to be unsupported?!?
It's supported in Hibernate (according to the HQL docs there)
I've also searched through the code of the project and found no references to anything that might look like a cast operation...
It's standard ANSI 92 SQL synta!!

Please help!!

Thomas

Can you create an Int32 property that converts to/from a string field in your class?

BOb

Probably, but I don't see how that is gonna help me since I need the conversion inside a max function and therefore the result of the cast becomes the input to my call to the aggregate max function...
This needs to be implemented in hql by modyfying the Dialect.cs and/or MsSql2000Dialect.cs files...

Though the good news is I've started on it, please if someone has some suggestions for how I should do this to make it good enough to maybe become patched into the main branch I'd be very pleased...
At the moment now I've implemented it in Dialect.cs, though the problems is the aggregate doesn't take only one argument, it takes a string and a type like this: "cast(myColumn AS int)" meaning it becomes garbled...

Thomas