Archives of the TeradataForum

Message Posted: Tue, 02 Sep 2003 @ 13:11:59 GMT

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

Craig,

The problem is that there are two forms of the substring function and they go like this:

substr(stringname, start, length)

and

substring(stringname from start for length)

Queryman is evidently interpreting your functions and correcting them.

Pat Belle
Certified Master

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