OraFAQ Forum: SQL & PL/SQL » function to convert string to integer

Home » SQL & PL/SQL » SQL & PL/SQL » function to convert string to integer

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

function to convert string to integer [message #9864]

Tue, 09 December 2003 17:12

pat
Messages: 27
Registered: September 2000

Junior Member

I am using TOAD to get a max value from a character field. I can not figure out a way to convert it to an integer so I can find the highest value. This is an example of what I am trying to do. Thanks

select max(to int(hoclientid))
from contact
where contacttype = 1 and recordtype in (1,2)

Report message to a moderator