Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 07 Dec 2005 @ 10:04:54 GMT


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


Subj:   Check Values is Numeric?
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, December 07, 2005 01:47 -->

Hi,

Is there any function to check a value is Numric?. suppose I have a tb1 say table1 and a column col1 as char(30). After inserting values('AAA','AAB',AAC','111') to col1 in the table tb1. How to check the values in col1 is numeric?. In this example value '111' is numeric and other values non numeric.


Thanks



     
  <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