Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Converting RAW to int?

Status
Not open for further replies.

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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top