14 Replies Latest reply: Sep 19, 2014 3:32 AM by Atsushi Saijo RSS

    How to convert a column into ('(value1)','(value2)',..)

    Atsushi Saijo

      Dear Gurus,

       

      Would you possibly advise how to convert values in a column into the form ('(value1)','(value2)',......)?

       

      Let's say there is unique values in a single column table;

      Unique
      a
      b
      c
      d
      e

       

      I would like to create something like

      SET vCOND=('a','b','c','d','e');

       

      I would highly appreciarte for your input.

       

      Atsushi