0

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT
  C.Text
FROM Comments C
JOIN Posts P ON P.Id = C.PostId
WHERE
  C.Text COLLATE Latin1_General_BIN LIKE '%[sS]ave%'
  AND (
    C.Text COLLATE Latin1_General_BIN LIKE '%[lL]ife%' OR
    C.Text COLLATE Latin1_General_BIN LIKE '%[dD]ay%' OR
    C.Text COLLATE Latin1_General_BIN LIKE '%[hH]our%' OR
    C.Text COLLATE Latin1_General_BIN LIKE '%[wW]eek%'
  )
  AND C.Text COLLATE Latin1_General_BIN NOT LIKE '%[tT]hank%'
  AND LEN(C.Text) <= 70
ORDER BY P.Score Desc
;

fork query

edited jan 26

created jan 26 anonymous