11 Replies Latest reply on Jun 4, 2006 9:45 AM by paross1

    ORDER BY

    JohnGree Level 1
      Hi i have this
      (CASE WHEN BB.TotalOuts = '0, 0,' THEN BB.Runs / BB.TotalOuts ELSE BB.Runs / 1 END) AS "AVER"
      from a QofQ

      this works fine but i need to order by AVER which dosnt work, i have 3 results

      104
      0
      5

      i think because of the "0" this is why it wont order by, if i am right how can i get over this problem?

      full code is