Sean, What do you mean i don't have a parameter??....I guess i have parameters look at my first post above...

like this..

==================================

ALTER PROCEDURE [dbo].[SearchBiography]

@firstname varchar(50),

@middlename varchar(50),

@lastname varchar(50),

@sex varchar(50),

@status varchar(50),

@sexID int,

@statusID int

==================================

firstname,middlename, lastname..etc are parameters of my stored procedure right?..