December 17, 2001
Here is some quality SQL;
SELECT decode(customer_class_code, '', 'Distributor', customer_class_code)
Someone should really learn how to use 'NVL'. Mind you, as I said to Mr Kelly when we found that code, this is the reason people like us are never going to be short of work.
Posted by Andy Todd at December 17, 2001 03:44 PM