0

Please login or register to vote for this query.

(click on this box to dismiss)

This retrieves all questions (and questions only) with a very short amount of characters (less then 30 in total).

Q&A for pro webmasters

-- Questions with a very short body.
-- This retrieves all questions (and questions only) with a
-- very short amount of characters (less then 30 in total).

SELECT Id                                             AS [Post Link],
       Replace(Replace(Body, '<p>', ' '), '</p>', '') AS [Question Body],
       Score                                          As [Total Score]
FROM   Posts    
WHERE  ( (PostTypeID = 1) And (Len(Body) < 30) )

fork query

created jul 27 11 Breakthrough