, 26 2020 . 21:55
+
MIF: , . metakey. /8 /16 /1 /2. .
DECLARE @T TABLE(metakey nvarchar(max))
INSERT INTO @T(metakey) VALUES(N'razdel-128.')
INSERT INTO @T(metakey) VALUES(N'me,razdel-12.')
INSERT INTO @T(metakey) VALUES(N'razdel-128,razdel-me,razdel-16.')
INSERT INTO @T(metakey) VALUES(N'razdel-128,razdel-merazdel-16.')
INSERT INTO @T(metakey) VALUES(N'razdel-128,razdel-me,anotherrazdel,razdel-16.')
SELECT *
FROM @T
WHERE metakey like 'razdel-%'
AND (LEN (metakey) - LEN(REPLACE(metakey, ',', '')))/2= (LEN(metakey) - LEN(REPLACE(metakey,',razdel-','')))/16
https://forum.sources.ru/index.php?showtopic=419400&view=findpost&p=3837759
