simple problem with datareader

Question

I've got this wierd issue: An ODBC driver to a legacy system sticks a '$' sign in front of the number on the Price column. I use an ODBC query tester to check my SQL statements and I can see this happening. According to the reader.GetSchemaTable this column is of decimal type. However any type of reader.GetValue .GetDecimal or ToString method I try causes an exception because of incorrect format. It rightly sees this typed as decimal but bonks on the dollar sign. So the question is: is there an 'agnostic' way to read this data so that I can strip the '$' out? Will gladly return help if anyone can assist me. TIA!

sgreenst · Answer

never mind... I figured it out. If I do Price * 1 it shifts the $ to a 4 changing the amount but now I can arithmetically fix it since it messes up all amounts exactly the same.