Hi all!
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 :/

you could try to convert by using int4(field) - this should convert the char to an integer value.

As dbabren says max(int4(id)) is what you want. Also the docs are online in PDF format here ftp://ftp.ca.com/pub/ingres/docs/

HTH
Paul

That's it
And thanks for the link, I'm sure that'' come in handy soon.