Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Ask questions, find answers and collaborate at work with Stack Overflow for Teams.
Ask questions, find answers and collaborate at work with Stack Overflow for Teams. Explore Teams
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
As commented by @Vince, ultiplyingmultiplying the target value to remove the decimal and then casting as an integer seemed to solve the problem.
I modified my SQL statement to read:
cast((Contour * 10) as int) = 5
and it worked like a charm.
As commented by @Vince, ultiplying the target value to remove the decimal and then casting as an integer seemed to solve the problem.
As commented by @Vince, multiplying the target value to remove the decimal and then casting as an integer seemed to solve the problem.
MultiplyingAs commented by @Vince, ultiplying the target value to remove the decimal and then casting as an integer seemed to solve the problem.
I modified my SQL statement to read "cast((Contour * 10) as int) = 5":
Multiplying the target value to remove the decimal and then casting as an integer seemed to solve the problem.
I modified my SQL statement to read "cast((Contour * 10) as int) = 5" and it worked like a charm.
