I need to typecast an char(12) field to int on an Ingres DB via IngresII ODBC driver. I keep getting "CAST is not a function" errors. My google-fu fails me and I don't have any documentation at hand.
To provide some background: There is a table with a field "ID" that only contains numerical values, but the type is char(12) (no way for me to change that, duh). I need to find out the highest value, but MAX(ID) returns the highest value ordered lexically :/