DECLARE @T TABLE(metakey varchar(max))
INSERT INTO @T(metakey) VALUES('razdel-128.')
INSERT INTO @T(metakey) VALUES('me,razdel-12.')
INSERT INTO @T(metakey) VALUES('razdel-128,razdel-me,razdel-16.')
INSERT INTO @T(metakey) VALUES('razdel-128,razdel-merazdel-16.')
INSERT INTO @T(metakey) VALUES('razdel-128,razdel-me,anotherrazdel,razdel-16.')
SELECT *
FROM @T
WHERE metakey like 'razdel-%'
AND LEN (metakey) - LEN(REPLACE(metakey, ',', ''))= (LEN(metakey) - LEN(REPLACE(metakey,',razdel-','')))/8
