Sorry, I should use this instead of my last post:

CREATE PROCEDURE sp_MySearch

@p1 varchar(50),

@p2 varchar(50)

As

select...

Hi, I think

ColumnOne = insnull(@pSearchArg, ColumnOne)

whill not work, because null value in ColumnOne will fail this expression.

I'd like to use something like the following...