 |
 |
Archives of the TeradataForum
Message Posted: Mon, 07 Dec 2009 @ 09:42:45 GMT
| Subj: | | Re: Find and replace substring |
| |
| From: | | Howard Bradley |
Paul
as many people have suggested, the best way would probably be to use a UDF. However, an alternative approach might be to use a recursive query
to "parse" the character string. I've done similar things in the past. It's often not pretty and can be CPU intensive when submitted against
larger tables, but it retains the processing logic within the "SQL" environment which may be a consideration for you (it often is for me).
| |
