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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.