Case Sensitive in the comparision of strings in SQL Server 7.0

[kalpana]

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?