https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/41870.aspxTue, 19 May 2009 14:52:48 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:41870swathip0https://www.infopathdev.com:443/forums/thread/41870.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=41870<p>Hello and welcome to forums,</p> <p>Once try by converting those values to numbers using number() function. I have tried using number function and it is working fine.</p>https://www.infopathdev.com:443/forums/thread/41727.aspxThu, 14 May 2009 19:13:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:41727stimpson0https://www.infopathdev.com:443/forums/thread/41727.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=41727<p>Alright, so I&#39;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.&nbsp; 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.&nbsp; 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.&nbsp; I have my data being stored in SQLServer, and I&#39;ve tried varchar, decimal, and float datatypes, but all result the same way.&nbsp; Any advice is helpful, thanks.</p><p>&nbsp;</p><p>Stimpson <br /></p>