I ran into a known issue with MS SQL Server 2005 that threw me for a loop. Essentially, casting a rounded float value as a string led to the number losing significant digits when the number of significant digits was greater than three. Ok, digest that for a minute: Values stored in the float datatype... Continue Reading →