Re: Like Bug with Sql Server 2005

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:880BBDF5-A36C-44C6-8777-13217452DF7B@xxxxxxxxxxxxxxxx
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?


.

Relevant Pages
Loading