Thanks Andy.

Could you please give an example.

NeoNash

I was also facing this problem for a long time and thanks for this tip. I will try immediately.

I worked around eachtime as follows(which is not a good way of...

Thanks Steve.

There is another question I have raised to better understand this case-sensitive and insensitive issue.

This one example of 'abc'='ABC' is a problem with case-insensitive.

Moreover, if we do select DISTINCT...

Thanks Andy,

That was quick and I will go through the article.

NeoNash

I am sorry this should have gone under "General" topic and I hope you don't mind.

Thanks,

NeoNash

Well. I tried and that seems to be evading in my case.

I am using a case insensitive SQLServer installation.

Here is the test case.

create table Test1 (

Username varchar(20) NULL

Constraint...

OK. I found a way. But I guess it must have some limitations.

Assuming only one record in Test1.

Test1

'This is my first value'

Test2 is empty.

Code:

declare

@a varchar(8000)

begin

select