kalpana
Oct 12th, 1999, 04:33 PM
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?
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?