Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

A program I use has SQL & RTF files to generate reports and I'm wanting to remove all instances of the - (minus) symbol from the resulting document.

I'd tried a SELECT REPLACE but I'm not very good with code and don't know how to select the whole document or if that's possible.

share|improve this question

closed as unclear what you're asking by RolandoMySQLDBA, Phil, Paul White, Max Vernon, Mark Storey-Smith Jun 13 '14 at 7:18

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

Which RDBMS are you using and what are the documents stored in? Edit your question with the table definition. – Phil Oct 25 '13 at 10:32
I hope that system is Sarbanes-Oxley compliant!d :-) – Vérace Jun 12 '14 at 23:00
Context: This was for issuing credit notes in an invoicing program that doesn't have that functionality built in. So I invoiced for negative values instead to adjust balances. Credit note documents however should show positive values as credit given. – user29816 Jun 13 '14 at 0:25
up vote 0 down vote accepted

Wrap each value that you wish to change from negative to positive with ABS. E.g.

share|improve this answer