Microsoft KB Archive/239077

BUG: CASE Function Fails in ORDER BY When Specifying Order by Column Position ID: Q239077 The information in this article applies to: Microsoft SQL Server version 7.0 BUG #: 56234 (SQLBUG_70) SYMPTOMS When you include a CASE statement within an ORDER BY clause and you specify a column position to order by rather than a column name, you do not receive any error messages, but the column you want to order by is ignored. WORKAROUND Instead of specifying the column to order by using the column's position, use the column's name. STATUS Microsoft has confirmed this to be a problem in SQL Server version 7.0. Additional query words: Keywords  : kbSQLServ700bug Version  : winnt:7.0 Platform  : winnt Issue type  : kbbug

Last Reviewed: September 7, 1999 © 1999 Microsoft Corporation. All rights reserved. Terms of Use.