Friends,<BR><BR>I'm trying to write a select statement that ends like this:<BR><BR><pre class="ip_ubbcode_code_pre"><BR>and sc.customer_name in (DECODE(shipto,'0',sc ...
--SYNTAX--DECODE (column name, number 1 to be searched, result 1 to be updated, number 2 to be searched, result 2 to be updated , number 3 to be searched, result 3 to be updated . . . . . . . . .