Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 27 Mar 2009 @ 17:40:46 GMT


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


Subj:   Casting to Integer Question
 
From:   Anomy Anom

<-- Anonymously Posted: Fri, 27 Mar 2009 12:03 -->

Given the following SQL...

     select cast('2/' as integer)

Does anyone know why the '/' does not cause an invalid conversion error? The slash just goes away... A '+' goes away as well. A '2-' returns -2



     
  <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