"Best" posts prior to 2010

Please login or register to vote for this query.

(click on this box to dismiss)

All questions that start with the word "Best" and were asked before 2010

Q&A for programmers

-- "Best" posts prior to 2010
-- All questions that start with the word "Best" and were asked before 2010

select
  CreationDate, Id as [Post Link], Body, Score from Posts
where
  upper(Title) like 'BEST%' and
  ParentId is null and
  ClosedDate is null and
  cast(CreationDate as DATE) < cast('2010-01-01 00:00:00.000' as DATE)
order by Score asc

created sep 14 11