0

Please login or register to vote for this query.

(click on this box to dismiss)

For some people, the enter key seems to be broken...

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

SELECT TOP 100 ph1.PostId AS [Post Link], LEN(ph1.Text) FROM PostHistory ph1 WHERE REPLACE(REPLACE(ph1.Text, CHAR(13), 'AWESOMENEWLINE'), CHAR(10), 'AWESOMENEWLINE') NOT LIKE '%AWESOMENEWLINE%' AND NOT EXISTS (SELECT ph2.Id FROM PostHistory ph2 WHERE ph2.PostId = ph1.PostId AND ph2.CreationDate > ph1.CreationDate) ORDER BY LEN(Text) DESC

fork query

created aug 20 11 TomWij