Re: Convert CHAR to INTEGER in a SELECT statement

create table f_temp( x integer); insert into f_temp select f_char from table;select max(x) from f_temp; drop table f_temp this will give you your max number assuming there are only numeric values in that char field. Gregg .......