Concatenating strings with new line format?
I want to concatenate 2 strings arranging the resultant output in a new line format..
example:
RTRIM ( DECODE (UPPER (VPA.safety), 'TRUE', 'Safety, ')
|| DECODE (UPPER (vpa.effectiveness), 'TRUE', 'Effectiveness, ')
|| DECODE (UPPER (vpa.timeliness), 'TRUE', 'Timeliness, ')
|| DECODE (UPPER (vpa.equity), 'TRUE', 'Equity, ')
|| DECODE (UPPER (vpa.efficiency), 'TRUE', 'Efficiency'),
'TRUE', 'Patient Centeredness'
),
', '
) AS Concat_Text
I want to display the above output in new line
Safety
Effectiveness
Timeliness
Equity
Efficiency
Edited by: francislazaro on Jun 14, 2010 7:34 PM