How can I remove the - after an import into a database. I want to be able to convert all negative numbers to positive, once the data has been imported into the table
Any ideas?
If you dont have too many rows (not in millions) you can run a quick UPDATE statement.
UPDATE yourTable SET colA = colA * -1 WHERE colA < 0
|||forgot to say thanks, did the trick.
No comments:
Post a Comment