Thursday, May 24, 2018

Case Sensitive String Comparison Sqlserver

declare @temp1 varchar(max)='naveen'
declare @temp2 varchar(max)='NaveeN'
if(@temp1=@temp2 COLLATE Latin1_General_CS_AS)
print 'Same'
else
print 'different'
--=======================================
IF EXISTS(select UserName from tbl_Users where UserName='naeven' COLLATE Latin1_General_CS_AS)
print 'Exists'
else
print 'Not Exists'

 

No comments:

Post a Comment

javascript Filter/index off

 var family = [{"name":"Jack",  "age": 26},               {"name":"Jill",  "age"...