Archives of the TeradataForum

Message Posted: Thu, 08 Jan 2004 @ 12:50:37 GMT

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

You could brute force check:

,     trim(substr(telephone,1,1))||
      trim(substr(telephone,2,1))||
      trim(substr(telephone,3,1))||
      trim(substr(telephone,4,1))||
      trim(substr(telephone,5,1))||
      trim(substr(telephone,6,1))||
      trim(substr(telephone,7,1))||
      trim(substr(telephone,8,1))||
      trim(substr(telephone,9,1))||
      trim(substr(telephone,10,1))||
      trim(substr(telephone,11,1) (Named ScrubbedTelephone)

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