Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Tue, 06 Jun 2006 @ 21:36:01 GMT





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




Subj:   Re: To find the n th instance of a character in a string
 
From:   McLeod, Terry



When UDFs first made an appearance, George Coleman of Teradata produced an "unofficial" set of them to mimic various Oracle functions. One of the main reasons for doing so, I believe, was to smooth Oracle-to-Teradata conversions by having equivalent functions to drop into place where needed during such conversions.

You may want to ask your Teradata representative to try contacting George -- or at least the correct department -- to inquire after a UDF to replicate the functionality of the Oracle INSTR function (he did create some at the time). I don't know what the availability of those UDFs is to non-Teradata personnel.


Regards,

Terry M. McLeod





     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008