InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 06 Sep 2008 01:46:05 GMT20http://www.teradata.com/teradataforum/Topic11089-9-1.aspxTry this....CASE WHEN TO.PRODUCT = 'Bag' AND From.PRODUCT = 'Bag' THEN ( CASE WHEN CP.TO_sale_TYPE = 'DYNAMIC' AND CP.From_sale_TYPE = 'DYNAMIC' THEN 'Sell' WHEN CP.TO_sale_TYPE = 'STATIC' AND CP.From_sale_TYPE = 'STATIC' THEN 'Sell-s' ELSE 'Sell-UNKNOWN' END )ENDMon, 31 Mar 2008 01:27:28 GMTkumarhttp://www.teradata.com/teradataforum/Topic11089-9-1.aspxCASE WHEN TO.PRODUCT = 'Bag' THEN (CASE WHEN CP.TO_sale_TYPE = 'DYNAMIC' THEN 'Sell' WHEN CP.TO_sale_TYPE = 'STATIC' THEN 'Sell-s' ELSE 'Sell-UNKNOWN' END ) CASE WHEN From.PRODUCT = 'Bag' THEN (CASE WHEN CP.From_sale_TYPE = 'DYNAMIC' THEN 'Sell' WHEN CP.From_sale_TYPE = 'STATIC' THEN 'Sell-s' ELSE 'Sell-UNKNOWN' END )Could these two case statements be combined using an 'In' or any other options could be done?Sat, 29 Mar 2008 09:08:13 GMTGoutham