Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 15 Jul 2013 @ 19:45:10 GMT


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


Subj:   Checking for numeric characters in each row of a particular column
 
From:   anne.k.kearney

Hi all,

Would anyone have any advice / thoughts on how best to approach the following?

One of our users is querying a production table and for a specific column (this column is of variable length and is a mixture of numerical and alpha characters) they wish to test, for each row, does it have less than or equal to 6 numerical characters.

If it has up to 6 numeric chars, then, they wish to set a counter and flag the check as a pass but if it has more then 6 numerical characters, then, they wish to set a counter and flag the check as a fail.

i.e. they wish to check each position in the row of that column and confirm if it is a numeric, if so count it, if not ignore it. If the count of numeric chars for that row in that column crosses a count of 6 numeric chars then this row fails the check, if less then or equal to a count of 6 numeric chars then it passes the check.

The option of stored procedures etc is not available to them due to site security restrictions so they are looking to code in sql

Would appre any input


Thanks Anne



     
  <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: 27 Dec 2016