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

Casey Crookston caseyc at IntelliSoftmn.com
Mon Aug 14 15:59:14 CDT 2006

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



More information about the thelist mailing list