In a vb.net 2010 application, I have a number that returns from a t-sql 2012 where the number can look like 009.99. Basically there is always 2 leading zeroes, a number, decimal point, and 2 numbers after the decimal point.
For formatting the number is a report, I would like to be able to replace the 2 leading zeroes with 2 blank values. I know that the value will be converted to a string in vb.net 2010. However I would like to know how to replace the value of 009.99 to actually be bb9.99 where b is a blank space.
Thus can you show me the code on how to accomplish this goal?