Archives of the TeradataForum

Message Posted: Wed, 11 Oct 2006 @ 13:29:52 GMT

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

Hi All,

We need to find out, if in teradata there is text replace function within SQL.

Ex: Something that will do following (single or multi-character) replacement

     Select "ReplaceFunctionName"('InputString', 'Input', 'Output')

Result:

     'Outputstring'.

     ("ReplaceFunctionName"('InputString', 'search text', 'replace text'))

Or if there is any other way by which we can get the same..

Thanks in Advance.....

Regards,

Rao

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