Archives of the TeradataForum

Message Posted: Thu, 27 Mar 2009 @ 01:38:32 GMT

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

     select
     ORG_CD,
     case
        when ORG_LEVEL='SUB_LOB' then 'Y'
     else 'N'
     End as "Sub_Lob_Indicator"
     from hr_nonhr ;

Cheers,

Jingchen

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