Tags with plus (+) in their name

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT      t.TagName       AS 'Tag Name',
            /* Excerpts that are too long, bust the link. */
            COALESCE (
                'site://q/' + CAST(t.WikiPostId AS nvarchar) + '|' + LEFT(e.Body, 100) + '...', '{empty}'
            )
            AS 'Tag Info'
FROM        Tags            t
LEFT JOIN   Posts           e on e.Id = t.ExcerptPostId
WHERE       t.TagName       like '%+%'
ORDER BY    t.TagName

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results