Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 27 Mar 2002 @ 14:40:10 GMT


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


Subj:   Re: teradata newbiee
 
From:   Patrick A. Belle

Dieter,

Volume 5 of the Teradata SQL Reference manuals has a complete description of the functions. Position is the ANSI equivalent of our old Index function which behaves similarly to your charindex function. You would use substring for both the 3rd and 4th columns in your projection, but you'd have to do some arithmetic to get the starting point for the 4th parameter to emulate the right function.

Pat Belle
Teradata Certified Master



     
  <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