Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


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


Subj:   Re: Checking for numeric characters in each row of a particular column
 
From:   Dieter Noeth

anne.k.kearney wrote:

  Thanks for the below much appre - unfort we are teradata 13.10 would there be anything similiar in 13.10 release?  


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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020