APEX

Hi,

I am having great problems achieving something that should be relatively simple. Cant find examples other than NVL in APEX help or on the web. I simply need to use a PL/SQL expression in a Dynamic Action to give the equivalent of the following decode statement -

decode(:P4_ITEM, '-1', '- All Values -',:P4_ITEM)

P4_ITEM has a multi-select LOV colon separated value returned ... 'abc:def'

If I try SQL Statement :- select decode(:P4_ITEM, '-1', '- All Values -',:P4_ITEM) from dual => gives the concatenation of 'abc' '& # 5 8 ;' ':def' as the result with '& # 5 8 ;' without spaces in between replacing the colon ???

Is there a syntactical CASE statement I can use as a PL/SQL Expression instead to return the result 'abc:def' ???

All the issues I am having with APEX is trying to find the correct syntax for items in various fields and I think a more comprehensive set of examples in the help files would be a good investment.

Thanks very much.