Archives of the TeradataForum

Message Posted: Thu, 24 Apr 2008 @ 16:56:40 GMT

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

I need to write an SQL on a text field. Basically the text field could contain any number of characters. I need to extract only the numeric. The field is VARCHAR(2000). Obviously a huge CASE statement for this large of a field would be tedious and probably resource intensive.

Has anyone done anything like this before?

Thanks

Craig

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