Help with SQL statement

[Simon Poon]

CREATE PROCEDURE sp_Get_Products_By_Search @SearchString nvarchar AS Select * from vw_Categories_Products Where ProductName LIKE '% @SearchString %' return @@rowcount How can i change it to a correct statement? Please help me. Thanks. Simon

[Mike Ellison]

Hi Simon. Would this work?

CREATE PROCEDURE sp_Get_Products_By_Search
@SearchString nvarchar
AS
BEGIN
Select * from vw_Categories_Products
Where ProductName LIKE '%' + @SearchString + '%'

return @@rowcount
END