Q&A for developers and end users of the Sitecore CMS and multichannel marketing software
SELECT TOP ##Limit:int?50000## c.Text AS [Text], 'site://posts/comments/' + CONVERT(nvarchar(20),c.Id) AS [Comment Permalink] FROM Comments c WHERE LEN(Text) >= ##MinCommentLength:int?0## AND LEN(Text) <= ##MaxCommentLength:int?500## + LEN('@##UsernameWithoutSpaces## ') AND ( LOWER(Text) LIKE LOWER('@##UsernameWithoutSpaces## %') ) AND c.CreationDate < DATEADD(dd, -##MinCommentAgeDays:int?0##, GETDATE()) ORDER BY c.CreationDate ASC