Archives of the TeradataForum

Message Posted: Thu, 27 Jul 2006 @ 16:13:27 GMT

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

There are two implementations because REPLACE comes in two forms:

     REPLACE(char, search_string , replacement_string)
     REPLACE(char, search_string )
      /* equivalent to specifying an empty string as replacement */

Using "overloading", both modules are declared to be specific implementations of the same logical function; based on the number and types of arguments supplied, the database will decide which to invoke.

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