Hi All,

I was using MS SQL Server 2000.

When I select user_name from [user] where user_name='minhpx'

Then Results as following:

minhpx
MinhPX
MINHPX

Above results is not difference between upper-case letter and lower-case letter?

Can you help me?

Thanks.

Best Regards.

Minh

1. Edit two records in Authors table in PUBS database. For one record changed the au_fname as 'Anne'. For the next record change the au_fname as 'anne'.
2. Execute the below query to see it doing a case sensitive search.

select * from authors where cast(au_fname as varbinary(8)) = cast('anne' as varbinary(8))

When we do binary comparison the values of 'A' and 'a' (first character of anne) doesn't match .. so you would get only one record as output

instead if you execute the below query it would show both the records as output,
select * from authors where au_fname = 'anne'

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com