Returning -ve value in a pattern

Dear Friends,

I need your help once more.
I want to write a simple select as follows

select amount from books
where sr=1234

However, if value of "Amount" is negative then it should print it as follows.

"3000-" and not as "-3000"

Can you help me in this?

Waiting for reply
Anu.

Hi

If your Oracle is 10g or above,

select regexp_replace(amount, '-(.*)','\1-')from books
where sr=1234

Guru.

No my code is in informix.
However, in informix standard SQL commands work.
So its fine even if you give me SQL statement.