Simple Member Search

I have created a simple stored procedure to which i send the following values

@strfirstname

@strsurname

@knownas

I want to search the members table for records matching any of the three using the LIKE statement however i don't want to have @strsurname LIKE '%%' how do i get around this in the stored procedure

yes but if nothing is passed in then i don't want all records to be pulled up.

I need some checking in the stored procedure to see if the value is null or not. It's when the value is null i'm not sure what to replace it with.

CREATE PROC spTEST
   @strfirstname VARCHAR(30) = NULL,
   @strsurname VARCHAR(30) = NULL,
   @knownas VARCHAR(30) = NULL
AS
IF @strfirstname IS NULL
BEGIN
    RAISERROR('Must supply value for First Name', 16, 1)
    RETURN -1
END

IF @strsurname IS NULL
BEGIN
    RAISERROR('Must supply value for Surname', 16, 1)
    RETURN -1
END

IF @knownas IS NULL
BEGIN
    RAISERROR('Must supply value for Known AS', 16, 1)
    RETURN -1
END

...the rest of your stored proc here...
GO