[thelist] To Store or Not to Store - Building dynamic queries

[Casey Crookston]

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