We are using SQL Server 7.0 and the Sort Order is default case insensitive, kana type insensitive, width insensitive.
When Executing the following query,
"Select Code,Name from test where code='1a'"
it returns the following result.
Code Name
1a ABC
1A XYZ
I want to get the result as follows:
Code Name
1a ABC
How to make the case sensitive only in the Sql Querys in comparing the
strings without changing the Sort Order?
