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://q/'+CAST(P.Id AS nvarchar(10))+'/11107541', [Len] = DATALENGTH(P.Body)/2 FROM Posts P WHERE P.PostTypeId = 2 AND (DATALENGTH(P.Body)/2) < 200 AND P.ParentId NOT IN (151974) AND P.Body COLLATE Latin1_General_BIN LIKE '%</a>%' AND P.Body COLLATE Latin1_General_BIN LIKE '%trirand.com/blog%' --AND RIGHT(P.Body COLLATE Latin1_General_BIN,10) COLLATE Latin1_General_BIN LIKE '%</a>%' ORDER BY DATALENGTH(P.Body) ASC ;