Archives of the TeradataForum

Message Posted: Wed, 17 Jul 2002 @ 16:48:50 GMT

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

Hi:

If the "-" is in different locations thru-out the data, you might try the following:

upd custtable
set custfield = Substring (custfield from 1 for index(custfield,'-')-1)
|| '_' || substring (custfield from index(custfield,'-')+1 ) ;

This is the simple SQL approach. However, you must run this once per '-' that occurs in the data. In other words, for acct-chg-it, you must run this twice and it changes one '-' to '_' per run.

Now, this can be done in one run, but the second substring must be a substring starting from the index value that points after the second '-'. I did not have time to sit down and test the more elaborate approach. If you wish to contact me directly, so that I know who you are, we can discuss the more elaborate approach.

Regards,

Mike

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