select * from ( select Title, CreationDate, substring(Tit...

0

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 *
from 
(
     select Title, CreationDate,
     substring(Title, 
       charindex('(', Title) + 1,       
       charindex(')', Title) - charindex('(', Title) - 1) as Tag
     from Posts 
     where title like '%()%'
) P
  inner join
  (
    select tagname
    from tags
  ) t
  on p.Tag = t.tagname

Enter Parameters

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