I got a feature request for SQLGridSelectedView to allow multi-answers so the user could use the T-SQL "In" feature. Specifically, the user, Paul Bennett, wanted a way to allow a copy and paste from Excel to be handled.
He wanted to pass in a column of Excel data containing Computername so he could do a Select like:
Select * from Requests where Computername in ( [Search:Text] )
While this would work for a single entry, I agreed that this is a worthwhile feature, so I added a Multi-Answer option to the TextSearch filters to allow the end-user to enter multiple entries. Each Entry must be on a separate line. If the entry ends with a comma (",") I will remove it. Blank lines will be ignored.
So the above example would expand to something like:
Select * from Requests where Computername in ( 'COMP1', 'COMP2' )
Each entry is enclosed in single quotes and separated by commas.

I have also added a similar feature to the Filter selections. When the Multi-Select option is selected, SQLGridSelectedView display a ListBox that allows the user to select one or more items from the displayed list.

Thanks Paul for a great suggestion.
Enjoy.