DB2/SQL Equivalent to Show Multi Value as Separate Entries?

HCL Domino Domino Forum
1

Notes gives you the option to show multiple values as separate entries…

Is there a way to accomplish the same thing using SQL/IBM DB2?

I am using a dynamic table in a query view, and need to:

  1. Show multi value as separate entries
  • AND -
  1. Filter those values in the SQL view selection formula, so that ONLY SOME of the entries end up in the view.

For example, I have a document with a multi-value field that contains: “Fruit” “Vegetables”

I need to display that document in a view, but only show the entry for “Fruit”.

Can this be done? And, if so, how?