I have a strange one. I am using the datatype DECIMAL in my SQL table. like this:
DebtAmount DECIMAL(17,2) NULL
If I insert values like: 100 or 10.5 or -10 they insert no problem.
The problem I am having is loads of my data has negative values that have it like 200- or 350- (you see the minus sign at the end of the value instead of before it)
When i bring them into excel they come in no problem with the minus sign before the value but SQL does not like the minus figure after the value. i cant really do anything about how the values import from our system this way so i was hoping i could work with sql on this issue.
error i get is: Error converting data type varchar to numeric.
Thanks
G
DebtAmount DECIMAL(17,2) NULL
If I insert values like: 100 or 10.5 or -10 they insert no problem.
The problem I am having is loads of my data has negative values that have it like 200- or 350- (you see the minus sign at the end of the value instead of before it)
When i bring them into excel they come in no problem with the minus sign before the value but SQL does not like the minus figure after the value. i cant really do anything about how the values import from our system this way so i was hoping i could work with sql on this issue.
error i get is: Error converting data type varchar to numeric.
Thanks
G