0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people who build and repair bicycles, people who train cycling, or commute on bicycles

select 
    Rtrim(replace(replace(Tags, '>',', '), '<',''), ', ') AS Tags,
    len(replace(replace(Tags, '>',','), '<',''))-len(replace(replace(replace(Tags, '>',','), '<',''),',','')) AS NumberofTags,
    Id AS PostId,
    OwnerUserId AS UserId,
    Body AS PostBody
from 
    posts
where
    len(replace(replace(Tags, '>',','), '<',''))-len(replace(replace(replace(Tags, '>',','), '<',''),',','')) > 4;

fork query

edited sep 20

created sep 19 anonymous