What's the equivalent of ISNUMERIC (from SQL Server) in HQL?
I'm doing a query that is going to find the max integer value from a column that can contain both integer and non-integer values (column type is string).
I need to find the value which is when converted the highest integer value existing in my column/table.

In Sql Server I would write something like:

SELECT MAX( CONVERT(BigInt, RTRIM(c.CustomerNo)) ) FROM Customers c WHERE (ISNUMERIC(RTRIM(c.CustomerNo)) = 1)

I don't know if CONVERT() is supported by NHibernate (as it has more than one parameter); for ISNUMERIC(), you may try it in HQL; it shouldn't be changed when generating the SQL...