Archives of the TeradataForum

Message Posted: Thu, 17 Jun 2004 @ 09:15:28 GMT

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

Hi,

I would like to extract only the numeric field out of a varchar field.

For e.g.

If the field contains data like "Today is 0403" or "Tomorrow is 0404" then how could extract only the numeric constant ?

I need to extract only 0404 or 0403

Thanks in advance.

Vijay

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