Archives of the TeradataForum

Message Posted: Sat, 27 Aug 2016 @ 08:12:36 GMT

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

I think you could REGEX to work around this problem.

     sel *
     from (sel
              'Vinay? T1
             ,'1Vinay1aa' T2
             ,'111' T3
             ,'1a11a' T4
             ,'Vinay1aa' T5)  FUBAR

     WHERE REGEXP_SIMILAR( T5, '(^[0-9].+)|($[0-9].+)|.[0-9].+' , 'i') = 1;

In the above SQL, change Column names to test whether numeric value exists. If the statement evalutes to true, then you will see the result set.

In this case, you should see an output for T2, T3, T4 and T5 column values.

Best,

Vinay Bagare

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