0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT 
    Comments.CreationDate,
    Comments.Id as [Comment Link]
FROM 
    Comments 
WHERE (
    Comments.Text LIKE ##Aa:string##
    OR Comments.Text LIKE ##Ab:string?NULL##
    OR Comments.Text LIKE ##Ac:string?NULL##
) AND (
    Comments.Text LIKE ##Ba:string?%##
    OR Comments.Text LIKE ##Bb:string?NULL##
    OR Comments.Text LIKE ##Bc:string?NULL##
) AND (
    Comments.Text LIKE ##Ca:string?%##
    OR Comments.Text LIKE ##Cb:string?NULL##
    OR Comments.Text LIKE ##Cc:string?NULL##
) AND (
    Comments.Text LIKE ##Da:string?%##
    OR Comments.Text LIKE ##Db:string?NULL##
    OR Comments.Text LIKE ##Dc:string?NULL##
)
ORDER BY 
    Comments.CreationDate DESC

fork query

edited mar 6 wizzwizz4 ♦

created feb 9 21 Jeff Schaller