 |
 |
Archives of the TeradataForum
Message Posted: Mon, 30 Apr 2012 @ 16:15:25 GMT
| Subj: | | Re: Extracting a String From End |
| |
| From: | | Dave Wellman |
Hi,
I don't think you can reaslitically do this using just SQL. I think you'll have to use a UDF, effectively you want an REVERSE-SUBSTRING
function, i.e. looking for the first position of char#1 when searching char#2 in reverse. You might want to check the existing Teradata UDF's to
see if there is something similar. If not, then get coding!
Cheers,
Dave
Ward Analytics Ltd - Information in motion (www.ward-analytics.com)
| |
