I guess this is the right forum. When I got at it from inside of Sql Server
Communities, t-sql was an option.

I am using SQL Server Management Studio to query a SQL Server 2000 database.
If I do this:

Select * from sop30200 where sopnumbe like '%197215%' I get 49 records.

If I do it in Sql Query Analyzer from the Sql2000 client side, I get 50.
The one that is missing in the first case is 'GWNCMR-197215'.

How come?

Are you 100% sure they are both pointing to the same server and database?
If so can you post the DDL for the table and the Insert statements for some
of the data we can have a look but for my simple test here it works fine in
2005.

--
Andrew J. Kelly SQL MVP

"MicroComputer Solutions" <MicroComputer
Solutions (AT) discussions (DOT) microsoft.com> wrote