https:

Archives of the TeradataForum

Message Posted: Fri, 26 Aug 2016 @ 09:20:28 GMT


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

Subj:		Re: Eliminate rows where data is having any character other than [0-9]

From:		Nachor, Sherwin

Hi,

You can also use the following condition as filter:

     REGEXP_INSTR(ColumName, '[^0-9]') = 0

Best regards,

Sherwin


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

Archives

2016 Indexes

Last Modified: 24 Jul 2020