4 Replies Latest reply on May 19, 2016 12:23 PM by rpschwar27

    Coldfusion v2016 using SQL server query using order by right causes error.

    rpschwar27 Level 1

      Have query that worked until v2016.  Using order by right(LogNumber,3) DESC get error:

      Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'right'

       

      query:

        SELECT LogNumber

        FROM tblMain

        WHERE (Program = 'Apple')

        ORDER BY right(LogNumber,3) DESC