Adding an ORDER BY has no effect.  It still takes over 5 minutes.

The execution plan using TOP shows that it's not using an index for the "TransNumber" field in...

I've tested the performance using each of the 4 suggestions and these are the best in order of performance:

1.  Jesper (extremely fast for all test cases)

2.  PW (fastest when it's only...

I'm using SQL2K.

I'm trying to SELECT all records where the Amount is a whole dollar.  I need to exclude all records where the Amount field contains cents.  Using Dinakar's suggestion:

SELECT *

FROM Sales

WHERE...

The DB2 server is running v7.2 fixpak 10a on Linux.  It used to be on IBM.  Everything worked perfectly under the IBM, but ever since it was moved to Linux,...

Yes, it works with everything else such as Oracle ODBC, text files, MS Access, etc...  We have DTS packages that gets data from these other sources.  The DB2 ODBC connection...