Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 29 Jun 2005 @ 15:25:03 GMT

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

Subj:   Re: Comma in string
From:   Victor Sokovin

  When I add a -1 as you did, to the substring in order to back out the comma, it throws an error in Teradata.  

I think you get this error for those addresses which do not contain any commas.

To fix this you might need to introduce something like CASE in your statement but as it was SQL elegance you seem to be primarily after I am not sure this suggestion would fit.



  <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