>>>For me it returns the first 2000 results sorted in descending order
>>
>>Then, I believe, this would be the correct behavior.
>
>No it is not, based on my tests. See Naomi's message on the syntax...
>
>Update: did you just change it? I just logged out, back in, and now it seems to be returning select top 2000 * from whatever order by desc
It is still incorrect. I put 'Download' as the search string and tried to search from 2001 to current date and it returned 2000 results starting from 2007, so it's not that easy.
It is probably union with old data tables?
If it's not broken, fix it until it is.
My Blog