When I’m using the SQL Query Builder and the Visual Designer to filter out items, the Where In filter ignores anything that is selected from the choice list if it has a comma in it.
To Reproduce:
-
Create a new Query Designer session comprising a selection of row data with string values that contain commas and some that don’t.
-
Select the Elipses for the Where clause on the column in question.
-
Select the IN filter for the Where clause and select every row populated by the Toad product.
-
Click Ok and then go back into the Where clause by clicking on the Elipses.
-
Notice how all of the items with Commas are ignored and removed from the Where selection.