'This SP lets us search for a customers name by typing in part of the name.
'Notice I used wildcards "%" and the word LIKE instead of =.



'=======================================================================================

ALTER PROCEDURE dbo.FindCustomer 
	@Name varchar (15)
	
AS
	SELECT *
	
	FROM customers
	
	WHERE Name LIKE '%' + @name + '%'

	
	
	
	SET NOCOUNT ON 
	
	RETURN


'======================================================================================

'This SP searches records for the State the customer is in.


ALTER PROCEDURE dbo.FindByState
	@State nchar(10)
	
AS

SELECT *

FROM customers

WHERE State = @State


 SET NOCOUNT ON 
	RETURN

'======================================================================================