How to use LIKE in a store procedure

How can you use a like-search in a SP
ALTER PROCEDURE dbo.spSearch
(
@.s varchar(50)
)
AS
SET NOCOUNT ON
SELECT * FROM tbl where name LIKE @.s
What is I need to do a '%@.s%' '
ThanksIt sounds like you might be looking for:
SELECT * FROM tbl where name LIKE '%' + @.s + '%'
Roy Harvey
Beacon Falls, CT
On Sat, 22 Apr 2006 00:47:56 +0200, "Michael Fllgreen" <mfa@.ulle.se>
wrote:

>How can you use a like-search in a SP
>ALTER PROCEDURE dbo.spSearch
> (
> @.s varchar(50)
> )
>AS
> SET NOCOUNT ON
> SELECT * FROM tbl where name LIKE @.s
>What is I need to do a '%@.s%' '
>Thanks
>