Apr 2, 2004 #1 ASmee IS-IT--Management Jul 9, 2002 46 US I want to convert a RAW column to an INT? I can convert it to a varchar2 with cast and have tried the following: select cast(cast(reportid as varchar2(20)) as int) from reports; I get the error invalid number.
I want to convert a RAW column to an INT? I can convert it to a varchar2 with cast and have tried the following: select cast(cast(reportid as varchar2(20)) as int) from reports; I get the error invalid number.