in my query can I convert a string to int

select convert(int,str_col) from table


I just need the order by, if there's a different way.

select str_col from table order by convert(int,str_col)

You're looking for the TO_NUMBER() function. You could supply various
format models for this if necessary but the following will get you
going.

select str_col from table order by to_number(str_col);

See the SQL Reference Manual for loads of info
(http://tahiti.oracle.com).

Cheers.

"Cindy Lee" <dangreece (AT) hotmail (DOT) com> wrote