3 Replies Latest reply on Apr 4, 2013 2:30 PM by jfb00

    Q of Q round number issue

    jfb00 Level 3

      Hi All,

      I cannot use round function in Query of Query. I can cast the number as integer like:

      <cfquery dbtype="query">

           select cast(myValue as integer) finalNumber

           from myQuery


      where myValue = 65.7, but the result is 65, it should be 66.

      It is a work around this issue?