Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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


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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020