SELECT DISTINCT TOP 10 SUBSTRING(temp, 0, CHARINDEX(':', temp + ':'))
FROM
(SELECT SUBSTRING(titel, 0, CHARINDEX(';', titel + ';')) AS temp
FROM [MergedDBs].[ova2].MarcRecord
WHERE titel LIKE 'is%')