FIX: Unexpected ordering when you run ORDER BY statement on a column that contains "-" in SQL Server Compact 4.0

Applies to: SQL Server Compact 4.0

Symptoms


Assume that you have a table that contains a column in which some row or rows contain a dash character "-" in Microsoft SQL Server Compact 4.0 Service Pack 1 (SP1). When you execute a SELECT query that contains an ORDER BY statement on the column, the returned result is not in an expected order and the returned number of rows is also incorrect.

Resolution


The hotfix that resolves this problem is included in an on-demand hotfix update package for SQL Server Compact 4.0 Service Pack 1.

For more information about how to obtain this on-demand hotfix update package for SQL Server Compact 4.0 SP1, click the following article number to view the article in the Microsoft Knowledge Base: 
2960153 On-demand hotfix update package for SQL Server Compact 4.0 Service Pack 1

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.