RE: Strange 'order by' - can anyone explain ?

One Orange Chip

Points: 26944

August 28, 2013 at 4:35 am

Is there some significance in 'AA' in Danish/Norwegian? It seems to sort after 'Z'

SELECT X

FROM (VALUES ('A'),('AA'),('B'),('BB'),('C'),('CC'),('Z')) T(X)

ORDER BY X COLLATE Latin1_General_CI_AS

SELECT X

FROM (VALUES ('A'),('AA'),('B'),('BB'),('C'),('CC'),('Z')) T(X)

ORDER BY X COLLATE Danish_Norwegian_CS_AS

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum