CREATE TABLE Names(
    [Name] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
);

INSERT INTO Names(Name) VALUES('Masse');
INSERT INTO Names(Name) VALUES('Maße');

SELECT *
FROM Names
WHERE Name = 'Masse'

DROP TABLE Names;

-- Output of SELECT
Name
----------------------------------
Masse
Maße