Negative at wrong end

[djj55]

Hello, SQL 2008R2
Is there an easy way to convert 25.00- to -25.00?
I have a file I import that has the negative on the right side, I import as varchar the do an update

UPDATE #SummaryTemp 
SET Purchases = CASE WHEN RIGHT(Purchases, 1) = '-' THEN '-' ELSE '' END  
            + REPLACE(Purchases, '-', '')

Is there a function or trick to do this a little easier. Note there are actually seven columns that get updated.

Thanks

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[markros]

I believe your way IS OK and should work.

PluralSight Learning Library

 

[djj55]

Thanks

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[WhoWantsTacos]

Is it coming back in your query like that or in the report? If it's in the report there should be a way to change the display settings for the field/column. Otherwise it's probably looking at a local setting on the machine to determine how to handle the negative numbers.

 

[djj55]

No it comes from the client like that as a pipe delimited text file that needs imported. The above works but was looking for a short cut (not udf).

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!