Archives of the TeradataForum

Message Posted: Thu, 25 Aug 2016 @ 21:34:43 GMT

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

<-- Anonymously Posted: Thursday, August 25, 2016 16:29 -->

Some additional options:

Use OTRANSLATE to remove 0123456789 (replace with empty string) and test the length of the result

Use REGEXP_SIMILAR [^0-9]

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