Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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

     0016_0100_0880_0191966150_PM
     0016_0100_0457_5274330_LIM
     0016_0100_0451__665_5120778110_ES
     0016_0100_0983_2902312130_PM

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


Thanks and Regards



     
  <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