 Re: How to compare the string with case sensitive in sql server?
Yeah..sure... Code: declare @Test int
if((encrypt('test')=encrypt('Test')))
set @Test=1
else if((encrypt('test')!=encrypt('Test')))
set @Test=0
select @Test as Result That’s it…
__________________ S.VinothkumaR
Behind me is infinite power,
Before me is Endless Possibility,
Around me is Boundless Opportunity,
Why should I fear!
|