CaseSensitive

[Balbir singh]

Is there any way to setup case sensitive or case insensitive for particular table.
we should not attempt to update the field all the time without checking if they are the same. The reason is, we have index on these field. Updating it all the time will cause a performance problem. Therefore, only update if the updated value is different from the original value.

[Balbir Singh]

You are right. I did like this.

declare @tt nvarchar(128)
declare @tt1 nvarchar(128)
set @tt='abc'
set @tt1='abC'

if cast(isnull(@tt,&#39;&#39 as varbinary(50))<>cast(@tt1 as varbinary(50))
print &#39;ok&#39;

Thanks for your help


------------
Paul at 12/14/00 6:50:05 AM

There is no easy way i am aware of, you can, however convert your characters to binary and compare those.


------------
Balbir singh at 12/13/00 6:50:16 PM

Is there any way to setup case sensitive or case insensitive for particular table.
we should not attempt to update the field all the time without checking if they are the same. The reason is, we have index on these field. Updating it all the time will cause a performance problem. Therefore, only update if the updated value is different from the original value.