Posts from users who possibly can't find the shift key

0

Please login or register to vote for this query.

(click on this box to dismiss)

Posts with length > 500 characters and no uppercase characters

Open Source Meta

Q&A about the site for people organizing, marketing or licensing open source development projects

-- Posts from users who possibly can't find the shift key
-- Posts with length > 500 characters and no uppercase characters

select top 50
p.id as [Post Link],
cast(p.body as nvarchar(4000)),
len(p.body) as "Length",
p.creationdate
from posts as p, posts as q
where p.id = q.id
and lower(cast(p.body as nvarchar(4000))) like cast(q.body as nvarchar(4000))
and len(p.body) > 500

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results