Archives of the TeradataForum
Message Posted: Tue, 18 Mar 2003 @ 15:06:32 GMT
<-- Anonymously Posted: Monday, March 17, 2003 12:36 -->
As you see performing such a thing using SQL needs some ugly case statements. The other way to do it is to export the data out into a file and use something like cobol, perl (depending on your environment) to strip the column of the non-alphas and Mload back into the table.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|