Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 30 Apr 2012 @ 16:15:25 GMT

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

Subj:   Re: Extracting a String From End
From:   Dave Wellman


I don't think you can reaslitically do this using just SQL. I think you'll have to use a UDF, effectively you want an REVERSE-SUBSTRING function, i.e. looking for the first position of char#1 when searching char#2 in reverse. You might want to check the existing Teradata UDF's to see if there is something similar. If not, then get coding!



Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

  <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: 28 Jun 2020