Home » SQL & PL/SQL » SQL & PL/SQL » To_Char Problems
To_Char Problems [message #2715] Wed, 07 August 2002 13:34 Go to next message
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...
Re: To_Char Problems [message #2716 is a reply to message #2715] Wed, 07 August 2002 13:48 Go to previous message
Eddie
Messages: 23
Registered: January 2001
Junior Member
App1.ap_FolderSummary is a VARCHAR2
Previous Topic: Accessing multiple schemas
Next Topic: SELECT DISTINCT command
Goto Forum:
  


Current Time: Fri Mar 29 03:24:16 CDT 2024