Q&A for people interested in conceptual questions about life and challenges in a world where "cognitive" functions can be mimicked in purely digital environment
SELECT [Post] = 'site://'+CAST(P.Id AS nvarchar(10)), [Len] = DATALENGTH(P.Body)/2 FROM Posts P WHERE P.PostTypeId = 2 AND (DATALENGTH(P.Body)/2) < 200 AND P.Body COLLATE Latin1_General_BIN LIKE '%</a>%' --AND RIGHT(P.Body COLLATE Latin1_General_BIN,10) COLLATE Latin1_General_BIN LIKE '%</a>%' ;