Some times if we want to update a table or query a table for multiple values in a single column we have to run our simple sql query multiple times. Suppose if you want to get an element value in a column of a table you normally run a select command as shown below. We will use the PATH option , which generates single elements for each row returned. If we use a regular query such as the following it will return the result set shown below. You can often use the IN operator instead to search for multiple values in the same data column.
In the Criteria Pane, add the column to search. In the Filter column for the data column you just adde specify the first condition. That is why you would use IN. Another way to look at it would be to use OR, but that gets really long winded.
You can either loop through the rows with a cursor and append to a field in a temp table , or you could use the COALESCE function to concatenate the fields. SQL dialect has a string search function (find in this case, but I think charindex for SQLServer ). SQL search multiple values in same field - Stack. SQL query for matching multiple values in. Dear all, I need to execute a query in vb which can find multiple value provided by the user to find from a single column of a table. Let me clear myself from this example: Table : Employee Column : Emp_Name User Input: George, Aldwin Required is to find with both inputs separated by commas or space.