Someone
public sql v1 · immutableSELECT DISTINCT TOP 10 SUBSTRING(temp, 0, CHARINDEX(':', temp + ':'))FROM(SELECT SUBSTRING(titel, 0, CHARINDEX(';', titel + ';')) AS tempFROM [MergedDBs].[ova2].MarcRecordWHERE titel LIKE 'is%')SELECT DISTINCT TOP 10 SUBSTRING(temp, 0, CHARINDEX(':', temp + ':'))FROM(SELECT SUBSTRING(titel, 0, CHARINDEX(';', titel + ';')) AS tempFROM [MergedDBs].[ova2].MarcRecordWHERE titel LIKE 'is%')