Archives of the TeradataForum

Message Posted: Tue, 16 Jul 2013 @ 20:27:53 GMT

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

anne.k.kearney wrote:

Some DBAs are very reluctant regarding those unoffical C-UDFs, but some functions like OTranslate or OReplace should be installed on every site.

You might talk to your DBA trying to convince him.

Any other solution would be much more complicated and use much more resources, e.g. recursion or extracting each character seperately:

     case when
         case when substr(col, 1, 1) between '0' and '9' then 1 else 0 end +
         case when substr(col, 2, 1) between '0' and '9' then 1 else 0 end +
         ... >= 6
     then 0 else 1 end

Dieter

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