Archives of the TeradataForum

Message Posted: Wed, 16 Jun 2004 @ 15:43:34 GMT

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

Is there a way to identify pure numeric out of alpha-numeric data? For e.g. if the below column is char(2) and contains alpha-numeric data do we have a sql function to identify 10,11,12 from bc ?

     A
     ---

     10
     11
     12

     bc

Thanks

Vivek

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