tags searching in sql server using asp.net

See more:

SQL

server

ASP.NET4

Hi,

there are 3 fields in my table ( type , id , tags ) . (tag(s) are separated by commas only in tags colunm)

when user enter any string , it should break into parts (by space) and the each part of that string should try to mtach through eachTAG in all rows of tags column , when it matches in any of the tag present in rows of TAGS column. those rows should be added in datable

how can i do it ?

Suppose

TYPE ||ID || Tags

typ1 ||1 || tag3,a,b,c

type3||2 || tag4,r,e
asf ||3 ||tag5,y,u,q,e,w
aaa ||4 || e,f,g,h

when user enter "tag3 r u"

the table shoud send these data of ID 1,2,3 and their types only by finding from tags column

Please provide query in stored procedure. im begineer

Thanks