Archives of the TeradataForum

Message Posted: Mon, 19 Jun 2006 @ 21:48:28 GMT

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

     SUBSTRING (ANSI) syntax is
       SUBSTRING(expression FROM start FOR length)

     SUBSTR (old form) is
       SUBSTR(expression,start,length)

The ODBC parser is quietly doing the translation for you when you use SQL Assistant.

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