Archives of the TeradataForum
Message Posted: Thu, 31 Mar 2005 @ 07:57:15 GMT
To get started with the data type conversion try something like
select position ('cessation' in sh.tobacco_comments) as cess1 , cast(cess1 as CHAR(100)) from table_name; .
If you like what you see you can nest the CASTs and or adjust the length of your strings (they might depend on the decimal type you get?), if you feel so inclined.
It might be useful to investigate the data type of the intermediate results and perhaps post them here as not many of us can have bteq on the mainframe to our disposal.
select type(position ('cessation' in sh.tobacco_comments)) from table_name;
should return this kind of information.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|