Archives of the TeradataForum

Message Posted: Tue, 02 Sep 2003 @ 13:04:46 GMT

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

BTEQ is not converting your syntax to an acceptable form:

Syntax for substring() (ANSI Function) is
substring(a from b for c)
where syntax for substr() (Teradata function) is
substr(a,b,c)

Hope this helps

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