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.