Archives of the TeradataForum

Message Posted: Fri, 09 Jul 2004 @ 20:05:05 GMT

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

I have a table that has a Varchar(50) column. It gets loaded automatically by a vendor. The column will have numeric and non-numeric data when it gets loaded.

Is there anyway I can set the non-numeric charaters to NULL or delete them using SQL?

Thanks

Ganga Palakattil

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