Execute the following script in Query Editor to create and execute the wildcard search stored procedure:

USE AdventureWorks;
GO
IF OBJECT_ID ( 'Production.procSearchProductList', 'P' ) IS NOT NULL
DROP PROCEDURE Production.procSearchProductList;
GO
CREATE PROCEDURE Production.procSearchProductList @Product varchar(40)
, @MaxPrice money

AS
SELECT Subcategory=s.Name,
Product= p.[Name],
ListPrice='$'+convert(varchar,p.ListPrice),
MaxPrice = '$'+convert(varchar,@MaxPrice),
Search = @Product
FROM Production.Product AS p
JOIN Production.ProductSubcategory AS s
ON p.ProductSubcategoryID = s.ProductSubcategoryID
WHERE s.[Name] LIKE @Product AND p.ListPrice < @MaxPrice
ORDER BY Subcategory, Product;

GO

EXECUTE Production.procSearchProductList '%Mountain%', 650