First - why would you possibly use a VARCHAR2 field to store numbers?

Regardless, simply do MAX(TO_NUMBER(field)). Of course, this will break if you have any non-numeric data in the field. There are other solutions on this forum to handle that, but I'm too lazy to look for them.

- Chris