Thursday, August 28, 2014

Sort order - Finnish_Swedish_CI_AS

Don´t get the sort order here: I would say that aggr_gem-01 and aggr_gem-02 should come next to each other - but apparantly not. - anyone know why ?



SELECT [name]
FROM [LagringsAdm].[dbo].[FLtest]
order by [name]

gives:

name

aggr_gem-01

aggr_gem01_mirr-01

aggr_gem01_mirr-10

aggr_gem01-04

aggr_gem01-12

aggr_gem-02



No comments:

Post a Comment