Archives of the TeradataForum
Message Posted: Tue, 16 Jul 2013 @ 20:27:53 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|