Archives of the TeradataForum

Message Posted: Mon, 11 Apr 2011 @ 09:39:37 GMT

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

Hi

You can try the following SQL:-

     SEL
     .
     .
     .
     ,trim(substr(substr(b.logonsource,55,17),1,index(substr(b.logonsource,55,17),'
     '))) .
     .
     FROM  dbc.AccessLog a,
       dbc.LogOnOff b

Thanks & Regards

Asim K Kanungo

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