Archives of the TeradataForum

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

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

<-- 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>>