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