I have a sort order question

I'm not sure what you are asking.  Can't you just use ORDER BY col DESC to find out?

select top 100 *
from myTable
ORDER BY DataString DESC

This is what I received when I ran the query in SQL Server

SEQ      Data String

1            2011-01-12-00.00.00.000000
 2           2011-01-12-XX.00.00.000000
 3           2011-01-12-XX-00.00.999999
 4          2011-01-12-00.00.00.999999

This is what my buddy received when he ran it in IBM mainframe world

 
SORTED DESCENDING:
SEQ   DATA STRING
4     2011-01-12-00.00.00.999999
1     2011-01-12-00.00.00.000000
3     2011-01-12-XX-00.00.999999
2     2011-01-12-XX.00.00.000000


Why the difference................?????

You will have to find a common collation in order to sort the same way.

So for example you could use something like this to change the sort order to match the mainframe:
ORDER BY YourColumn COLLATE SQL_EBCDIC037_CP1_CS_AS

8080_Diver:  

Do you still have the query you used......if you do can you please post.  

Thank you so much for your help

algotube,

I must confess, I didn't use a query but, rather, just my knowledge of how the results would come out.

However, the query has already been posted (see response #35507991):

SELECT SEQ
      ,LTRIM(DataString)
FROM myTable
ORDER BY LTRIM(DataString) DESC

Select allOpen in new window

 In looking at the output you say you got, though, it would appear that you omitted the ORDER BY LTRIM(DataString) DESC line.

Guys I can't thank you enough for all your replies, very very much appreciated