Hi All,
This might seem like a redundant question but I checked a lot of answers but nothing seem to work.
I created a data connection using MS Query trying to query in SQL Server. It is not a complicated query that I am using. The query is trying to select 5 columns from a table. In the where clause I have a parameter which needs to select multiple text values from one/multiple cell.
So consider this as the query:
select a1, a2, a3, a4, a5 from table1
where a6 in (0,1)
and a7 in ([param1])
The values I have in excel are something like below.
Param1
abc cde
efg ghi
and so on.
The param1 is dynamic in both number of values and the value itself.
I tried using the parameter value as Equals and well as Is One Of.
When I try using one column it works fine but If I concatenate the column to use values like "abc cde,efg ghi" it doesnt work. Ofcourse it does not allow me to select a range of columns.
Thanks in Advance for any help.
Regards,
Lisa
Bookmarks