Archives of the TeradataForum

Message Posted: Thu, 25 Aug 2016 @ 21:33:31 GMT

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

Also can use the approach to eliminate known good characters compare what's left to be present. If you translate 0-9 to spaces and compare the result equal to zero....

     Where otranslate(myField,'0123456789','2020202020202020'xc) = ' '

Kyle Prescott Technology Capability Manager
Unum - Infrastructure Services
Chattanooga, TN

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