Archives of the TeradataForum
Message Posted: Fri, 08 Apr 2011 @ 19:00:02 GMT
I'd like to generate only Userid (RANDERSON) through below SQL. I don't want anything to be generated after Userid in that column. How should I modify substr line?
--SQL SEL . . . ,substr(b.logonsource,55,17) as "UserID" . . FROM dbc.AccessLog a, dbc.LogOnOff b --Output of UserID column. RANDERSON WINDDI 01
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|