Why does varchar and nvarchar return different resultset in search?

[NewsBot]

CREATETABLE #TEST (Keyfield varchar(30)NULL)

INSERTINTO #Test (keyfield)VALUES('M-S Logistics');

INSERTINTO #Test (keyfield)VALUES('Monster Racing');

INSERTINTO #Test (keyfield)VALUES('Mueller Farms');

DECLARE @Search ASnvarchar(30), @Search2 ASvarchar(30)

--Query 1

SET @Search ='Monster Racing'

SELECTTOP(1) keyfield FROM #Test WHERE keyfield >= @Search;

--Query 2

SET @Search2 ='Monster Racing'

SELECTTOP(1) keyfield FROM #Test WHERE keyfield >= @Search2;

-- Why does query 2 return different result than query 1

 

More...

 

View All Our Microsoft Related Feeds