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