Hello!
I wonder how to select a conditional value from a Table column that has lists of values?
Example: I have a table in the database that looks like below:
| ID | Itemname | IDList |
| 1 | TestItem | 1 7 10 17 |
For example, I want to know which Itemname it is for number 10 that is in the IDList. What should this SQL syntax look like? I have tried %INLIST and other things but only get blank value. How should the SQL-syntax for that query look like?
Greatful for all tips.
Regards,
Michael