ASP multiple search forms using a SP

[flebel]

Hello,

I'm using a 3 form input search form to return a result of Author names, example Name, FirstName and Title. I'm using a SP to search with these 3 inputs to return a recorset. Is using the Like with the '%' the best way to do so? What about if the fields are empty? Does someone have an example so that my SP is not too long?

Thank you,

Francis

 

[anilkutty]

CREATE PROCEDURE getAuthors

@Name varchar(20)='' ,
@FirstName varchar(20)='',
@Title Varchar(40)=''

AS

SELECT Name, FirstName, Title from
Authors
WHERE
( @Name = '' or Name like +'''+@Name + '%' + ''') and
( @FirstName = '' or FirstName like ''' + @FirstName + '%' + ''') and
(@Title = '' or Title like + ''' + @ClaimNumber + '%' + ''')

Try this