To_Char Problems [message #2715] |
Wed, 07 August 2002 13:34 |
Eddie
Messages: 23 Registered: January 2001
|
Junior Member |
|
|
Hi guys just wonering if you guy can help me out with this query.. I am trying to change the field from
$999,999.99AUD to 999999.99 and this is what I am using
TO_CHAR(trim('$' from substr(App1.ap_FolderSummary,1,length( App1.ap_FolderSummary)-3)),'999999.99'),
*
ERROR at line 3:
ORA-01722: invalid number
And that error is stopping me....I cant work it out...Any help is appreciated...
|
|
|
|