5

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

SELECT COALESCE(Score, 0) AS Score,
       PostId             AS [Post Link],
       Id                 AS [Comment Link],
       UserId             AS [User Link]
FROM   Comments
WHERE  Text LIKE '%' + ##SearchString:string## + '%' ESCAPE ##EscapeChar:string?\##
ORDER  BY CreationDate DESC

fork query

edited may 5 12

created apr 4 12 e