What's the opposite of CodeLess Questions?Perhaps CodeOnly Answers? (Also known as code dumps.)Inspired by the opposite question, here's the opposite query: SELECT Id AS [Post Link], Score, CreationDateFROM PostsWHERE PostTypeId = 2  -- answers  AND Body LIKE '<pre><code>%'  AND CHARINDEX('</code></pre>', Body) + LEN('</code></pre>') = LEN(Body)  AND ClosedDate IS NULLORDER BY CreationDateChecking a couple of the results, this successfully finds the code only answers, and pretty fast.I'm wondering if there's a better, cleaner approach that the hack with the CHARINDEX.
The opposite of CodeLess Questions query
sql;sql server;stackexchange