Top + Order By = Strange Results

Hi there,

I'm a little bit confused here.

I the TOP 1 function with ORDER BY DESC to get the last id in my table but it doesn't seems to work.

Here's an example:

SELECT TOP 1 ID FROM Worksheet WHERE Style='302' AND Notes='Automatically created from m0851System.' AND Title='STD COST UPDATED FORM m0851System' ORDER BY ID DESC


SELECT ID FROM Worksheet WHERE Style='302' AND Notes='Automatically created from m0851System.' AND Title='STD COST UPDATED FORM m0851System' ORDER BY ID ASC


So basically the first SELECT should return the last id value of the second query but it doesn't.

The first query gives me that: 60721

And the second one gives me that:
60680
60681
60683
60684
60685
60686
60718
60719
60720
60721
61050
61122
61124

So as you can see my TOP 1 ID ORDER BY ID DESC should gave me this result: 61124


Am I missing something or... ?


Please help me this is aleready in function so I have to fix it ASAP.

Thank you,
Regards,

OR-THO