RE: Can TO_NUMBER Do This?

From: Jamadagni, Rajendra <rajendra.jamadagni_at_espn.com>
Date: Mon, 28 Aug 2000 14:41:36 -0400
Message-Id: <10602.115670@fatcity.com>

SELECT '(1234.56)',

       DECODE(ASCII(SUBSTR('(1234.56)',1,1))-40, 
		0,

0-TO_NUMBER(REPLACE(REPLACE('(1234.56)','('),')')),'(1234.56)') FROM dual

i.e. a plain TO_NUMBER won't do .....

HTH
Raj

---

Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
QOTD: Any clod can have facts, but having an opinion is an art ! Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. Received on Mon Aug 28 2000 - 13:41:36 CDT