MS Sql Server and Windows 2000/XP - 07-08-2004 , 03:14 AM
Hi, I have a problem.
I have two computers (clients), one with Windows 2000 and second with
Windows XP. And a third computer (server) with a Windows 2000 and MS Sql
I have a TABLE with two rows: 'row' and 'row ' (space).
And SQL: 'select * from TABLE where row = 'row'
If I run this SQL on computer with Windows 2000 it works ok (return only one
If I run this SQL on computer with Windows XP it works really strange
(return two rows: 'row' and 'row ' ) - it can't see this spaces.
Is there differences between MS Sql Server on W2000 and WXP?
Thanks for the help
Re: MS Sql Server and Windows 2000/XP - 07-08-2004 , 05:17 PM
slonk0 (slonk0_usun_to (AT) wp (DOT) pl) writes:
the SET command that may affect this. However, I am at loss to see
how you ever could get only one row back. You should always get two
back, because SQL does not care about trailing spaces when comparing.
Could you post a repro which demonstrates the problem? Such a repro
would have to create the table, insert the data, and then select.
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Books Online for SQL Server SP3 at
Re: MS Sql Server and Windows 2000/XP - 07-09-2004 , 04:02 AM
spaces when comparing.
Thanks for your help.