 |
 |
Archives of the TeradataForum
Message Posted: Mon, 02 Jul 2007 @ 12:32:42 GMT
| 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
| |
