Archives of the TeradataForum

Message Posted: Mon, 20 Oct 2003 @ 14:32:56 GMT

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

I am not aware of a Replace function in Teradata. You will be able to write a UDF for this in V2R5.1. (I think the PS folks already have done this.)

If you are using Queryman / SQL Assistant you can use the Replace function built into its Query window ... but that is only really helpful if you are returning only a row or 2 of data. (Cutting and pasting the answers into the Query window is much too slow if you have many rows to deal with.)

Alternatively you can save the output to a Text or Excel file and use the Replace functions provided by Word, Notepad, or Excel.

You can also use this alternative if you are using BTEQ or another query tool.

Mike Dempsey
Teradata Client Tools

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