Microsoft KB Archive/239077

{|
 * width="100%"|

-

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
 * }