I have one input parameter in stored procedure.i want to find out that wether that string parameter contains the "Special" word or not.how will i seach this word in stored procedure?

I don't understand what you mean. On the most basic level you would do:

SELECT [something] from [table] where [field] like @param + '%'

"The one language all programmers understand is profanity."

actuallly i have one string parameter in my stored procedure.i want to find some specific words in that string in my stored procedure.like
create procedure test
as
str varchar(100)
begin
//i want to search wether str string contains 'abc' word or not
end

how will i do that

You could do it like...

If (Charindex('abc',@str)>0)
  -- do something

or better yet

if (@str like '%abc%')
  -- do something


Harsh Athalye
India
"Nothing is impossible"