If your database is defined as case-insensitive (controlled at installQuote:>What is the best way to create a case sensative query? The "like"
>statement is not doing it.
The only way I know of to perform a case sensitive test in a
case-insensitive database is to do it character by character using the
is there a way to make the existing SQL Server7 case sensitive. i.e. to
have two tables like
Table1 and table1. and also make it effective on select queries also.