>On a similar subject, do you know how to perform a case-sensitive search on a database that is set to case-insensitive?

You can do a case-sensitive search by CASTing the values to Binary datatypes:

CAST(column AS varbinary(40)) = CAST(literal AS varbinary(40))

-Mike