SQL query that distinguishes between ß and ss

You need to use a binary collation so that it's case-sensitive, accent-sensitive, etc.

Collation: SQL_Latin1_General_Cp437_BIN