Archives of the TeradataForum

Message Posted: Fri, 06 Apr 2007 @ 18:17:56 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Anom,

If col_1 have low cardinality

     Case when col_1 = 1
          then cast ('20070228' date format 'YYYYMMDD')
          else cast ('28022007' date format 'DDMMMYYY')
          end

If col_1 have high cardinality:

     Case when col_1 = 1
          then cast ('20070228' date format 'YYYYMMDD')
          else case when col_1 = 2
                    then cast ('28022007' date format 'DDMMMYYY')
          end

Regards,

Ramu.

	<Prev	Next>		<<First	<Prev	Next>	Last>>