SSN field does not sort in correct order when sorting a query

When sorting a query by SSN, the query does not sort in the correct order
 We are currently evaluating this issue and will update this article when we have more information. 

Steps to Duplicate

1. Click Query>New Query
2. Select Constituent from the Query type drop-down
3. Click the Output tab
4. Select Constituent Information>Constituent ID, Import ID, System Record ID, SSN
5. Click the Sort tab
6. Select Constituent Information>SSN
7. Click Run Now
8. The query does not sort the SSN column in a logical manner

Environment

 Raiser's Edge
 7.94
 Duplicated in 7.91, 7.92, 7.93. and 7.94

Was this article helpful?