@parameter for Like stored proc in sql server? - Inetserver

You have your parameter in ', so it'll be treated as the literal string,
"@StoryTitle."

Do:

CREATE Procedure spr_GetStoryTitle
@StoryTitle VarChar(100)
As
set nocount on
SELECT *
FROM Story
WHERE (StoryTitle LIKE '% ' + @StoryTitle + '%')
return
GO

I'm assuming you intended to have the space preceding @StoryTitle.

Ray at work

<jason@catamaranco.com> wrote in message
news:uV9XjrujFHA.320@TK2MSFTNGP09.phx.gbl...
> Could someone tell me if this parameter stored query is correct? Its not
> throwing up errors BUT also not returning any records...unsure if
> concentation is somehow needed to tie it all together?
>
> Are the apostrophe's needed...do i perhaps need '+' symbols?
>
>
> CREATE Procedure spr_GetStoryTitle
> @StoryTitle VarChar(100)
> As
> set nocount on
> SELECT *
> FROM Story
> WHERE (StoryTitle LIKE '% @StoryTitle%')
> return
> GO
>
> Thanks in advance
> Jason
>
>