Archives of the TeradataForum
Message Posted: Wed, 30 Mar 2005 @ 18:33:34 GMT
I am running BTEQ on the mainframe. I want to use CAST, or similar function, to output the results in a readable char format.
My statement attempt is:
cast(cast(position ('cessation' in sh.tobacco_comment) as cess1) as char(03)),
Any clues or corrections would be appreciated.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|