Do you have an ORDER BY clause in your SELECT statement?
>I have a database that all of a sudden doesn't want to perform any queries with the TOP clause. For example, following code used to work but now it doesn't.
>
>SELECT TOP 1 * FROM ListOrder
>
>Anyone know what's going on? TIA.
Chris McCandless
Red Sky Software