0

Please login or register to vote for this query.

(click on this box to dismiss)

Posts containing a body that is less than 8 chars long

Q&A about the site for software quality control experts, automation engineers, and software testers

-- Posts containing a very short body
-- Posts containing a body that is less than 8 chars long

select Id as [Post Link], 
Replace(Replace(Body, '<p>', ' '), '</p>', '') as [Body], 
Score 
from Posts 
where Len(Body) < 64 
AND Title <> 'undefined'
AND PostTypeID = 1

view current version

edited nov 29 Rubn.Rivera

created may 24 10 sam.saffron