Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 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.

2  
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 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. –  Alexm7b5 Jun 13 at 0:25

1 Answer 1

up vote 0 down vote accepted

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

SELECT
ABS(value)
share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.