Archives of the TeradataForum

Message Posted: Tue, 18 Mar 2003 @ 15:06:32 GMT

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

<-- Anonymously Posted: Monday, March 17, 2003 12:36 -->

Hi Ramesh,

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.

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