Archives of the TeradataForum

Message Posted: Wed, 17 Jul 2002 @ 13:59:15 GMT

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

Alas, no. When V2R5 is available, you will be able to define your own functions to do stuff like this. Since this kind of task is needed so often, however, I think the TRANSLATE function should be extended to allow translation from any set of characters to any other.

In the meantime, if the list of strings to be converted isn't too big, you could convert them with a join.

create table string_conversions
(old_string varchar(50),
new_string varchar(50) ) ...;
insert string_conversions ('CUST-ACCT-I', 'CUST_ACCT_I'); /*... and so on */

select ... b.new_string ...
from wherever a, string_conversions b
where a.old_string = b.old_string ...;

You get the idea, I'm sure.

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