SET EXACT ON in MSSQL

Is that any similar command in MSSQL like Oracle SET EXACT ON/OFF so that case-sensitive query can be performed in case-insensitive database instance.
LVL 1
chnelsonAsked:
Who is Participating?
 
acampomaCommented:
You can only convert to varbinary to use case sensitivity
Be sure to do the same where clause without the varbinary conversion to use indexes before finding actual values.
where Name = 'John'
and convert(vabinary(20),Name) = convert(vabinary(20),'John')

0
 
chnelsonAuthor Commented:
what's brilliant idea!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.