Do you know how I can use a wildcard in the dynamic SQL Stored Procedure? Where sometimes I will have a value for the LIKE and sometimes it will be a wildcard? I&#039d want the command to be LIKE &#039%&#039 sometimes and LIKE &#039%&#039 + @LASTNAMNE + &#039%&#039 sometime, and there are actually ten variables that could have a value or a wildcard, how would I create the Stored Procedure and ASP code?<BR>I read the articles on Stored Procedures and Dynamic SQL, but I am still missing a piece, can anyone help?