Does anyone know if SQL Server is case sensitive? I ask this because when I perform comparisons between string variables and fields in ADODB Recordsets case does not seem to matter. For example, if I compare hello and HELLO, they are considered the same string. However, my application needs to be case sensitive.

Does anyone know what could be happening, and how I can "turn on" this case sensitivity?

I think it may have something to do with the Option Compare statement, but by default it should be a binary compare.

TIA,

Nahid