select Count(*) Result from posts where patindex(%crap%,words ) > 0

Result

-----

A LOT

if that is the answer you are excellent at guessing because I couln't understand it at all

can you post an example of the output ?

boy, slow down

LOL

there will be injection if strong typing is not used to gather the values and yes it is true that when the activity is not big it is not going...

No but when it happens the burst is so massive that lots of people know about it

why dyniamic? I concat at client side, No sp call  

It has happened more than what we all think

OR:

INSERT dbo.MySurvey_Marketing_Skills_User(User_ID, Skill_Rank, Skill_ID )

            select 1, 3, 67

union all select 2, 4, 56

union all select 3, 2, 43

N I C E !

are those all possible formats or could there be more?

How do you know the type of the column EventID ?

If EventID is "int" then you can solve the problem with the in ( ) operator. Charindex construct was for character values

You should look at the details:

at the begining of...

Like it or not that's how you learn... experience