Archives of the TeradataForum

Message Posted: Mon, 02 Jul 2007 @ 12:32:42 GMT


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

Subj:		Re: The last occurance of a character

From:		D silva, Joseph Vinish

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

You can use a UDF or recursive query to accomplish this.

Regards

Joseph D'silva


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

Archives

2007 Indexes

Last Modified: 15 Jun 2023