Greetings All,

I have tried both SUBSTR() and F_RIGHT() both of which return an error:
arithmetic exception, numeric overflow, or string truncation

For example if I try this simple select in Database Workbench I receive the
error.

SELECT F_RIGHT(SYSTEM_NOTE, 1000)
FROM ACCT_TRAN_DETAIL_TASK
WHERE ACCT_TRAN_ID = :V_ACCT_TRAN_ID
AND ACCT_TRAN_DETAIL_ID = :V_ACCT_TRAN_DETAIL_ID
AND ACCT_TASK_ID = :V_ACCT_TASK_ID

The field is a varchar(2000) field and contains carriage returns and line
feeds.

Any help appreciated...

Here is an example of the text contained in the field

2/15/2010 4:57 PM: Sent to Shawnee, KS Third Judicial District Court,
awaiting response.

2/17/2010 11:58 AM: Received response from Shawnee, KS Third Judicial
District Court.


The following submission error was returned:
Submission Line: This client account has already been used with 09L XXXXXX
Error: The filing fee should be $37.00(+$10.00) not 0.00 $84.00.

The task was automatically reset to scheduled.

2/24/2010 5:04 PM: Sent to Shawnee, KS Third Judicial District Court,
awaiting response.

2/25/2010 2:36 PM: Received response from Shawnee, KS Third Judicial
District Court.


The following submission error was returned:
Submission Line: This client account has already been used with 09L XXXXXX
Error: The filing fee should be $37.00(+$10.00) not 0.00 $84.00.

The task was automatically reset to scheduled.

3/5/2010 6:36 PM: Sent to Shawnee, KS Third Judicial District Court,
awaiting response.

3/8/2010 1:48 PM: Received response from Shawnee, KS Third Judicial District
Court.


The following submission error was returned:
Submission Line: This client account has already been used with 09L XXXXXX
Error: The filing fee should be $37.00(+$10.00) not 0.00 $84.00.

The task was automatically reset to scheduled.

3/10/2010 4:29 PM: Sent to Shawnee, KS Third Judicial District Court,
awaiting response.

3/11/2010 8:43 AM: Received response from Shawnee, KS Third Judicial
District Court.


The following submission error was returned:
Submission Line: This client account has already been used with 09L XXXXXX
Error: The filing fee should be $37.00(+$10.00) not 0.00 $84.00.

The task was automatically reset to scheduled.

3/16/2010 11:07 AM: Sent to Shawnee, KS Third Judicial District Court,
awaiting response.