Select decode (n1, 'E', 'D', n1) from test1 ; -----Original Message----- SRIDHARAN, SAN (SBCSI) Here the output from the table test1 Select * from test1; N1 --- A B C D E F Is there an Oracle function or is there a Sql statement that will print the following result without us create a function. Result ----------- A,B,C,D,D,F -- //www.freelists.org/webpage/oracle-l