This discussion is archived
0 Replies Latest reply: Mar 19, 2013 3:52 AM by 973331 RSS

Convert comma-separated parameter list to upper case

973331 Newbie
Currently Being Moderated
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?

Using 10.1.3.4.1

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points