Getting the max of a char field

Hi,

I have a table T1 and column c1 that is a char, but contains integers. What I want, is to get the max of these values:
"select to_num(c1) from T1" gives me the integer values
"select max(to_num(c1)) from T1" or even "select max(NUM) from (select
to_num(c1) NUM from T1)" gives me an error:
"ORA-01722: invalid number"

Has anybody any idea how to get this max? Thanks Received on Fri Nov 26 1999 - 02:54:05 CST