0 Replies Latest reply: Mar 19, 2013 5:52 AM by 973331 RSS

    Convert comma-separated parameter list to upper case

      I have a report that has a parameter called KitItemList that is defined as a "Text field contains comma-separated values " Text field.

      I want to be able to convert the parameters entered to upper case but it does not work to simply say upper(:KitItemList) in my select statement.

      So I have tried the following

      WITH t AS (SELECT :KitItemList AS Item FROM dual)
      SELECT upper(Item) FROM t

      but only one (the last) element of the list is returned.

      How do I get the constituent comma-separated entries to upper case?