Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 10 Mar 2005 @ 18:18:26 GMT


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


Subj:   Re: Distinguish chracters from intergers
 
From:   Victor Sokovin

          Where CASE WHEN UPPER(STRNG) (CS) = LOWER(STRNG) (CS)
                     THEN 1 ELSE 0 END = 0
  You can add this in your where clause... It will filter out the char values leaving numbers behind.  


I am sorry for nitpicking but this clause won't filter out *all* the chars as I tried to demonstrate in a few threads on this forum. If you have non-ASCII chars in your DB, please refer to the thread in my previous posting. It shows an example of the char which the filter will let through. There are many more examples of this kind.


Victor



     
  <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: 15 Jun 2023