I have a query that compares 2 numbers. The query works for almost all situations such as:
5.8'>5.7'
8'>7.5'
13.7'>11.9'
but it has some situations that when it evaluates the numbers it gets the following answers:
8.9'>10.8'
9.7'>10.6'
5.9'>18'
Why are these comparisons not working correctly?
What can I do to get the correct answers?
Thanks for help