Alright, so I've got a repeating table with a bunch of values in it, and I am judging to see if one value is between two boundary values. Most of the time this works, but whenever I am comparing the boundary values have their greatest value in a different place (tens, hundreths) the comparison fails regardless of when the entry value is. For example, if I am comparing 99.98 to see if it is between 99.97 and 99.99, it will pass, but it will fail if I am comparing it to 99.97 and 100. I have my data being stored in SQLServer, and I've tried varchar, decimal, and float datatypes, but all result the same way. Any advice is helpful, thanks.
Stimpson