You are correct; my oversight in mentioning that I am using the to_number function.
TurkBear <john.greco_at_dot.state.mn.us> wrote in message news:<l3i6pu49j3ir1jbl6rkka0sj3r98j6itt8_at_4ax.com>...
> Why an error - Max uses an implicit conversion to ASCII for the entire string in the Varchar2 field and computes the Max
> SQL> select max(empl_nm) from hr_public;
>
> MAX(EMPL_NM)
> --------------------------------------------------
> Zwart,Benjamin Jacob
>
> SQL>
>
> If you are, however, using the To_Number function first, then you will get that error..
>
Received on Fri Sep 27 2002 - 10:21:42 CDT
