Casey Crookston wrote: > 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 > > No, you can't do math on a string like that. (greater than space?) If you have something like: search: <select name="srchtype"><option value="books">Books</option><option value="cd">CDs</option></select> for: <select name="srcw"><option value="title">Title</option><option value="author">Author</option></select> <input type="text" name="textfield" /> You could do something like this: pass srchtype and srcw in as a parameter to the SP (this will depend on your scripting language) then in the SP, set @queryString = 'SELECT * FROM ' if @srchtype = 'books' begin set @queryString = @queryString + 'BOOKSTABLE' if @srcq = 'title' begin set @queryString = @queryString + ' WHERE title = ' @textfield else set @queryString = @queryString + ' WHERE author = ' @textfield end end end end That's just quick and probably missing some quotes in the syntax, but i think you get the idea.