=======================================================
Here is the MS SQL code used to generate the two Stored 
Procedures
=======================================================

'* Below is the first stored procedure that loads the
products into the data grid view.
/**********************************************
SP: up_Product_Retails_Catalog_Get
This stored procedure will load the products 
for retails customers to view and select for 
making a regular order.
**********************************************/


CREATE PROCEDURE up_Product_Retails_Catalog_Get

AS

SELECT ProductID, ProductName, Description,
RPrice as 'Price',
MinRQuant as 'Minimum Quantity'

FROM Products






'*Below is the stored procedure for the search engine.
/**********************************************
SP: up_DBExample_Search
This stored procedure will search for a product
using the search engine format.
**********************************************/


CREATE PROCEDURE up_DBExample_Search

@Product varchar(30)

AS

SELECT ProductID as 'ID', ProductName as 'Name', Description,
RPrice as 'Price',
MinRQuant as 'Minimum Quantity'

FROM Products
WHERE ProductName like @Product