All columns have to be of the same data type AND length. That was the only way I got mine to work, by converting them all to varchar(50).

If I...

Good article, though I would chnage this query:

--EXECUTE ProductSearch5 'CA%', 'Black', 375

CREATE PROCEDURE ProductSearch5

(

@ProductNumber VARCHAR(20),

@Color VARCHAR(10),

@ReOrderPoint INT

)

AS

SET...