Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 02 Jul 2007 @ 11:25:49 GMT

  <Prev Next>  
Next> Last>>  

Subj:   The last occurance of a character
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, January 21, 2004 07:04 -->

Hello All,

I have to do a CASE based on the pattern after the last '_' underscore in a string of variable length. Can you please give me pointers as to how this can be achieved? Here is a sample of the data


I need to CASE on the values 'PM, 'LIS' 'ES' etc. How do I isolate these?

Thanks and Regards

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