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?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×