Web Listing 1: GetCustomersByState Stored Procedure

/****** Object: StoredProcedure [dbo].[GetCustomersByState]
        Script Date: 09/19/2007 11:54:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[GetCustomersByState]
      (
            @StateWanted char(2),
            @NameHint NVarChar(20) = '%'
      )
AS
      IF CHARINDEX('%',@NameHint)=0 SET @NameHint=@NameHint + '%'
      SELECT DISTINCT CustID, TID, CustName, Discount, DateAdded,
                      TimeStamp, LastName, Photo, Notes
      FROM Customers AS C
      WHERE (Lastname LIKE @NameHint) 
            AND (SUBSTRING(@StateWanted, 1, 1) = '*') OR
        (CustID IN (SELECT CustID 
                    FROM Biblio.dbo.Addresses AS Addresses_1
                    WHERE (StateCode = @StateWanted)))
      ORDER BY LastName
      RETURN
GO