Brian - thanks for your help. I wasn't too clear on what I was really asking: Will this kind of syntax work in a stored proc? if @param1 > '' set @queryString = 'SELECT * FROM table WHERE ' + @whereString Thanks! Casey