0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for administrators, end users, developers and designers for Craft CMS

SELECT TOP 100
    c.Id AS [Comment Link],
    c.PostId AS [Post Link],
    c.Text,
    c.CreationDate
FROM
    Comments c
WHERE
    c.CreationDate < '2012-06-02' AND
    c.Text COLLATE SQL_Latin1_General_CP1_CI_AI LIKE ##PAT:string##
ORDER BY c.Id

fork query

edited mar 29

created mar 29 Henry.Ecker