I use to apply varbinary clause to go for a case sensitive search.Suppose for the case
SELECT * FROM EMPLOYEE WHERE
I am getting the correct result in every way.
But when I apply the same rule in the following way
SELECT * FROM employees WHERE
I am not getting any result wheather I pass the correct case sensetive parameter or not.
Can anybody help me why there is a difference in these two results?
One thing I like to mention in the first case the data type is varchar and in the latter case the datatype is nvarchar.Is this not applicable to the fields of type nvarchar.